Valentina Studio is a cross-tool for database architects, developers, DBAs and even end users to work with the most popular RDBMS such as MySQL, PostgreSQL, SQLite, SQL Server and ValentinaDB. You can do data modeling using different diagrams, work with database schema and records, do SQL development, do server administration, etc.
In PRO Edition ($199) you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. This project can be used in multi-user way if you put it under Valentina Server.
In PRO Edition ($199) you can develop a Valentina Project where design Reports and Forms automating them using JavaScript. This project can be used in multi-user way if you put it under Valentina Server.
FREE Edition brings you powerful, visual editors including:
- Diagram Editor - design your new db here then generate tables and other db objects from that diagram.
- Schema Editor (tree view and column view) - create and modify all schema objects of supported databases: Tables, Views, Fields, Enums, Links, Constraints, Triggers, Indexes, Stored Procedures, ...
- Data Editor - easily browse table records in a grid, modify records, inline edit of values, sort, filter records and save favorite filters, preview images, hex editors for binary values, ...
- Related Data Editor - easily learn and manage linked records of two tables, link/unlink records by a mouse click, do set operations over linked records, ...
- SQL Editor - with color syntax, auto-completion, recent an saved favorite queries, templates, console with error/warning reporting, ...
- Query Builder - build SQL queries visually using just a few mouse clicks.
- Server Admin - where you can manage users, learn logs and other parameters of servers.
PRO Edition adds more tools:
- Valentina Project - keep here reports, forms, javascripts
- Form Editor - design forms
- Report Editor - design reports
Open as many editors as you like at the same time for different databases/servers opened in tab-panels. You also get different DB related utilities, including Import/Export, Dumps, Diagnose, Clone, Reindex, ...
Version 8.7.1:
New:
- Valentina:
- Valentina Studio now can connect to Valentina Embedded Server without the special signature
- Diagram Editor:
- Show/Hide of some FK relations within a diagram
- Diagram with ALL tables of a database. In the dialog "Add Tables" you can select a checkbox [x] option: Add Existing Tables
- Drag and drop multiple tables and other objects from the left-side panel to a diagram
- SQL Editor:
- Drag and drop objects of a schema from the left sidebar of SQL Editor into the edit area. On drop, a dialog appears, where you can choose which command you want to generate and additional options
- Underline Not Resolved Identifiers in major SQL commands (Pro)
- "From Code" transformation. Removes quotes and escapes in the text copied from e.g. C# or PHP into SQL Editor, in order to get a clean SQL query ready for execution within Valentina Studio (Pro)
- Execute Current button, which allows executing of only one SQL statement, where the text cursor is located (Pro)
Improvements:
- SQL Editor:
- Indent/Unindent commands now work from the start of the line, not from the current cursor position
- Valentina:
- Show encryption key and repeat entry
- Report Editor:
- Improved report printing for some printer drivers
Fixes:
- Diagram Editor:
- Collapse lists of objects
- Fixed wrong query for deleting few child objects
- Dialog to save diagram's changes on closing the source database
- Printing diagram as SVG on macOS produces unreadable files
- Schema Editor:
- SQL Server - Schema Editor doesn't display databases on some SQL server instances
- MySQL - Schema editor in tree mode does not show primary key values when PK is multi-column PK
- MySQL:
- Dump from MySQL databases with default string values fails when importing
- Valentina:
- Dump fields of DOUBLE type if they don't have defined scale
icon. Plus, keep all your apps updated.
Valentina Studio User Discussion