Valentina Studio Pro 10.1.1
Valentina Studio is the ultimate data management tool for database administrators. Valentina Studio includes a wealth of database administration tools. Valentina Studio PRO to unlock advanced data modeling tools, report design and editing and more.
Valentina Studio brings you powerful, visual editors for your data including:
- 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, …
- Diagram Editor - design new diagrams or do reverse engineering, e.i explore existing databases visually.
- Data Editor - easily browse table records in the grid, modify records, an 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 and saved favorite queries, templates, console with error/warning reporting, …
- Query Editor - build SQL queries visually using just a few mouse clicks
- Server Admin - where you can manage users, learn logs and other parameters of servers.
MAS version of Valentina Studio uses iCloud to share bookmarks between your devices!
Valentina Studio Pro as an in-app purchase to get additional advanced pro-features such as:
- Report Editor - visual editor of Valentina Reports that can be saved into Valentina Project file (.vsp). Reports can use as datasource MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB, ODBC.
- Form Editor - visual editor of Valentina Forms that can be saved into Valentina Project file (.vsp). Forms can use all supported databases as the datasource.
- Data Editor - enables go to parent record function.
- Data Editor Layouts - save columns and their order as a named layout
- Data Editor Multiple Update - update few records at once.
- Data Transfer - copy data between different databases
- Diagram Editor - enables forward engineering - i.e. generation of SQL scripts for new/changed database objects.
- Dump Wizard - enables filter for tables to select them for a dump.
- Error Lookup - search for error description by its code.
- Keyboard Shortcuts - enables the ability to redefine the shortcuts and create own shortcut sets.
- Object Colors - enables marking objects with specific colors.
- Query Editor - enables the ability to copy the generated query.
- Schema Cache - save and reuse the schema cache.
- Schema Editor - copy one or few schema objects using drag&drop mechanism.
- Schema Editor - expanding and collapsing the tree items with subitems using OPTION + click
- Schema Snapshot - save and load schema in structured format.
- Source Control - develop database using any VCS.
- SQLDiff - find differences between two states of a databases and generate SQL script to move between these states.
- SQL Search - search of schema objects.
- SQL Editor - enables autocompletion for table aliases.
- SQL Editor - format SQL queries.
- SQL Editor - edit the result of SQL queries.
What's New:Version 10.1.1:
- [Bookmarks] Synchronization of bookmarks and SQL snippets via Cloud Storage folder (e.g. Dropbox, Google Drive).
- [SQL Editor] SQL Snippets now can be linked to one or more databases.
- [Schema Editor][Pro] Duplicate command in the contextual menu of a Table.
- [Schema Editor] Cmd+F keyboard shortcut moves focus to the search field on the top right.
- [Schema Editor] Added ability to filter the first column with databases in columns mode.
- [Form Editor][jаvascript] Added QCoreAppliction.processEvents() static method which can be used during long-running loops (for example, to show the progress, process button clicks).
- [Query Editor] Added an ability to duplicate a query of the Query Editor.
- [Data Editor] Fixed adding a related record for a binary link.
- [Form Editor] Fixed adding a new record in a form.
- [Form Editor] Fixed applying a custom font for all widgets.
- [Form Editor] Fixed highlighting of jаvascript Template Strings (e.g. `some string`).
- [Report Editor] Fixed execution of reports with multiple jаvascript-based expressions.
- [SQL Editor] Fixed hiding of autocompletion menu when we type string longer than any existing.
- [Data Editor] Allowed the user to open SQL Editor, Query Editor, Server Admin for active database/connection, using toolbar buttons.
- [SSH] Fixed sending long packets via SSH. This makes the execution of long queries more stable.
- [Load Dump] Update dump loading progress more frequently.
- [Load Dump] Show the list of errors on the last page of the Load Dump wizard.
- Title: Valentina Studio Pro 10.1.1
- Developer: Paradigma Software
- Compatibility: macOS 10.12 or later 64-bit
- Language: English
- Includes: K'ed by TNT
- Size: 69.08 MB