Valentina Studio is the best way to transform your data into meaningful information; create, administer, query and explore Valentina DB, MySQL, Postgre and SQLite databases for free on 32/64 bit Windows, Linux and Mac OS X.
Get Valentina Studio for Free. Get started managing your data by requesting a free license to Valentina Studio. Upgrade to Valentina Studio Pro for more advanced features. Upgrading to Valentina Studio Pro is easy - just order a key and enter it into Valentina Studio. Restart and all features become active.
Valentina Studio Overview and Key Features
Valentina Studio Key Features
Powerful, easy to use and free. Create, edit, query, import and administer popular databases: Valentina DB, MySQL, Postgre and SQLite with help of the following tools:
- Manage multiple databases and multiple operations in tabs and dockable views
- Create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views, Stored Procedures, Properties, Sequences, Types, ...
- Property Inspector displays and allows editing of common properties of all objects or multiple different objects at the same time
- Use Tree and Column Views for drilling down and quick searching database to table to fields
- Diagram Editor with reverse engineering - create diagrams for your existing database(s). You can also add new objects to diagrams.
- Browse/sort/filter records
- Inline and special editors
- Sort columns by mouse click
- Preview images
- Write SQL queries fast using auto-completion, color syntax
- Define and manage favorite queries
- Recent queries
- Function browser with description of each function
- Consoles to show errors, warnings, performance information
- Search result records
- Export result records into CSV, JSON, Excel, ... formats
- Add/drop users, groups, manage privileges
- Watch live logs, run diagnostics
- Register/unregister databases
- Create/Alter Schedule events
- Diagnose, compress, clone, defragment, reindex and dump data, ...
And a lots more features. All features available on 32 and 64 bit natively on Windows, Linux and Mac OS X.
Valentina Studio Pro Key Features
Expands what you can do with Valentina Studio with new features and advanced tools.
- Data Transfer to copy records between different databases. Datasources can be mySQL, PostgreSQL, SQLite, Valentina DB and ODBC.
- Diagram Editor supports powerful forward engineering features. Generate SQL scripts for changes and new objects.
- Import of XCODE Model
- Report Editor transforms queries into visually stunning enterprise reports with full suite of design elements: charts, graphs, barcodes, grids, images, html objects, labels, text boxes and more. Reports are saved into Valentina Projects - run Valentina Projects locally with Valentina Reports ADK or serve reports from Valentina Server; export reports as PDF, images, text.
- Query Builder to build SQL Queries by mouse clicks
- SQL DIFF helps you locate and track changes between two data sources; you don't need to spend hundreds of dollars on a separate utility for SQL DIFF!