Valentina Studio is the last word information administration software for database directors. Valentina Studio features a wealth of database administration instruments. Valentina Studio PRO to unlock superior information modeling instruments, report design and modifying and extra.
Valentina Studio brings you highly effective, visible editors in your information together with:
- Schema Editor (tree view and column view) – create and modify all schema objects of supported databases: Tables, Views, Fields, Enums, Hyperlinks, Constraints, Triggers, Indexes, Saved Procedures, …
- Diagram Editor – design new diagrams or do reverse engineering, e.i discover current databases visually.
- Knowledge Editor – simply browse desk data within the grid, modify data, an inline edit of values, kind, filter data and save favourite filters, preview photos, hex editors for binary values, …
- Associated Knowledge Editor – simply study and handle linked data of two tables, hyperlink/unlink data by a mouse click on, do set operations over linked data, …
- SQL Editor – with coloration syntax, auto-completion, latest and saved favourite queries, templates, console with error/warning reporting, …
- Question Editor – construct SQL queries visually utilizing only a few mouse clicks
- Server Admin – the place you possibly can handle customers, study logs and different parameters of servers.
Open as many editors as you want on the identical time for various databases/servers opened in tab-panels. You additionally get totally different DB associated utilities, together with: Import/Export, Dumps, Diagnose, Clone, Reindex, …
MAS model of Valentina Studio makes use of iCloud to share bookmarks between your gadgets!
Valentina Studio Professional as an in-app buy to get extra superior pro-features corresponding to:
- Report Editor – visible editor of Valentina Studies that may be saved into Valentina Mission file (.vsp). Studies can use as datasource MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
- Kind Editor – visible editor of Valentina Varieties that may be saved into Valentina Mission file (.vsp). Varieties can use all supported databases because the datasource.
- Knowledge Editor – allows go to father or mother document perform.
- Knowledge Editor Layouts – save columns and their order as a named format
- Knowledge Editor A number of Replace – replace few data without delay.
- Knowledge Switch – copy information between totally different databases
- Diagram Editor – allows ahead engineering – i.e. era of SQL scripts for brand new/modified database objects.
- Dump Wizard – allows filter for tables to pick them for a dump.
- Error Lookup – seek for error description by its code.
- Keyboard Shortcuts – allows the power to redefine the shortcuts and create personal shortcut units.
- Object Colours – allows marking objects with particular colours.
- Question Editor – allows the power to repeat the generated question.
- Schema Cache – save and reuse the schema cache.
- Schema Editor – copy one or few schema objects utilizing drag&drop mechanism.
- Schema Editor – increasing and collapsing the tree objects with subitems utilizing OPTION + click on
- Schema Snapshot – save and cargo schema in structured format.
- Supply Management – develop database utilizing any VCS.
- SQLDiff – discover variations between two states of a databases and generate SQL script to maneuver between these states.
- SQL Search – search of schema objects.
- SQL Editor – allows autocompletion for desk aliases.
- SQL Editor – format SQL queries.
- SQL Editor – edit the results of SQL queries.
- Launch notes have been unavailable when this itemizing was up to date.
macOS 10.12 or later, 64-bit processor