Valentina Studio provides powerful visual editors for your data including:
* Schema editor (tree or column view) – create and modify all schema objects of supported DBs: Tables, Views, Fields, Enumerations, Relationships, Constraints, Triggers, Indexes, Stored Procedures, …
* Diagram editor – draw new diagrams or reverse engineer, i.e. study an existing database visually.
* Data Editor – easily view table records in a table, modify records, edit values directly in cells, sort, filter and save frequently used filters, image viewer, hex editor for binary values, etc.
* Linked Data Editor – Explore and manage records in two related tables.
* SQL editor – with syntax highlighting, autocompletion, query history and saved queries, templates, console with errors/warnings, and query analytics.
* Query Editor – Create SQL queries visually with just a few clicks.
* Server Admin – where you can manage users, view logs and other parameters of the database servers.
Open as many editors as you need for different databases and servers in TAB panels. You will also get various utilities such as: Import/Export, Dump, Diagnosis, Cloning, Reindex, …
Valentina Studio allows you to sync bookmarks and snippets between your devices using iCloud or by saving to a cloud storage folder.
***See also: Valentina Studio Pro ($199)***
* Report Editor – visual editor of Reports that can be saved to a Valentina project file (.vsp). Reports can use the following databases as a data source: MS SQL, mySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
* Form Editor – visual editor of Forms that can be saved to a Valentina project file (.vsp). Reports can use all supported databases as a source.
* Data Editor – Gets a jump to the parent record.
* Data Editor – Layouts – save columns and their order as a named layout.
* Data Editor – Multiple Update – update multiple records.
* Data Transfer – Copy data between different databases.
* Diagram editor – receives forward design, i.e. generation of SQL scripts for new/changed database objects.
* Dump Master – Gets a filter of tables to select them for dumping.
* Search for errors – search for error descriptions by their number.
* Keyboard Shortcuts – Allows you to redefine shortcuts and create your own sets of shortcuts.
* Query editor – gets the ability to copy the generated query.
* Schema caching – saves and uses the database schema to increase the speed of working with remote servers.
* Schematic Snapshot – You can save and download the schematic in a structured format.
* Version control – develop databases using version control.
* SQL difference – finds the difference between two DB states and generates an SQL script for the transition between these states.
* SQL search – performs searches on schema objects.
* Schematic Editor – copy one or more schematic objects using drag and drop.
* SQL Editor – autocompletion for table aliases.
* SQL editor – formatting SQL queries.
* SQL Editor – editing the result of SQL queries
* Object colors – the ability to mark an object with a specific color.
Software Specs
Version: 15.1.4
Activation (RG): K’ed by TNT team
Compatibility: macOS 10.14 and later
Architecture: x86 (64-bit)
Size: 190 MB
Please log in to post a comment.
Register