Feature Comparison of Valentina Studio vs Valentina Studio Pro

You can try PRO features within the free Valentina Studio. Some of these features are limited until you upgrade to the full version of Valentina Studio PRO. This page describes how exactly you can try a PRO feature in the FREE version.

Mac App Store version of Valentina Studio does not have any demo features because of limitations of Apple's Mac App Store policies. Download Valentina Studio from Paradigma Software to get access to the demo features.

Valentina Studio PRO adds the following major features (in alphabet order):

  1. Data Transfer
  2. Form Editor
  3. Forward Engineering in Diagram Editor
  4. Keyboard Shortcuts Modify
  5. Object Colors
  6. Report Editor
  7. Query Editor
  8. Schema Caching
  9. Schema Editor: Drag & Drop of objects.
  10. Schema Editor: Expand/Collapse sub-tree by Option/Alt click.
  11. Schema Snapshot
  12. Scripting in JavaScript
  13. SQL DIFF
  14. SQL Editor: Static Analyzer, Advanced SQL Editing, SQL Parameters Binding, SQL Formatting …
  15. Source Control
  16. … and more minor features…

Take a look at each of the features of Valentina Studio Pro you can try within the free Valentina Studio.

The FREE version refers to Valentina Studio, which you can download and use for free.

The PRO version refers to Valentina Studio Pro, the commercial upgrade from Valentina Studio.

SQL Editor

SQL Editor allows you to type and execute a SQL query, see result of the query and other information about query (errors, warnings, timing, …).

Read More about SQL Editor Features...

Table Alias Autocompletion

  • FREE: Autocompletion of all supported objects and types.
  • PRO: Autocomplete for table aliases.

 SQL Editor - autocomplete

Advanced Editing

With this feature SQL Editor is completed with the following advanced query editing actions:

  • Duplicate Line
  • Move Element Left
  • Move Element Right
  • Move Statement Down
  • Move Statement Up
  • Move Line Down
  • Move Line Up

Parameters

This feature allows you to assign values to parameters in the SQL queries.

 SQL Editor - Parameters

Formatting

This feature allows you to format the text of SQL query.

  • FREE: Formatting can be done once after each start.
  • PRO: Formatting can be applied the unlimited number of times.

Read More...

Result Editing

This feature allows you to edit the result of SQL query.

  • FREE: View the result of the SQL query.
  • PRO: Edit result records and apply changes.

Read More...

Underline Unresolved Idents

This feature allows you to mark unresolved identifiers in major SQL commands.

See picture:

Execute Current Statement

This feature allows you to execute the statement with a text cursor.

"From Code" Operation

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.

Data Editor

Data Editor is a tool for editing and viewing data in tables and related tables.

Go to parent record

This feature allows you to navigate to a parent record using value of the Foreign Key or ObjectPtr fields.

Read More...

 Data Editor - Go to parent record

Layouts

Layouts feature allows you to tune how the table content is displayed.

Read More about Data Editor Layouts...

  • FREE: Select columns for show or change their order, changes are not saved anywhere
  • PRO: Ability to save changes made to columns list and their order as a named layout

 Data Editor - Layout

Multiple Update

This feature allows you to update multiple rows at once.

Read More about Data Editor Multiple Update...

  • FREE: Update only one record
  • PRO: Ability to update value for all shown records in some column.

 Data Editor - Multiple Update

Paste Tabular Data

This feature allows you to copy tabular data (e.g. from Excel, Calc, a table in the browser) and paste it into the table as the new rows.

Data Transfer

This feature allows you to copy records between two different databases. This feature is different from simply importing data.

Use the Data Transfer Wizard to choose one database (mySQL/postgreSQL/SQLite/Valentina/ODBC) to be a 'sources' database. Then choose another database (mySQL/postgreSQL/SQLite/Valentina) to be a 'target' database. You can then specify mapping of source/target tables and fields and load records from db1 to db2.

  • FREE: Load of records do not happens actually.
  • PRO: Use all features of Data Transfer.

Read More about Data Transfer Features...

Data Transfer - Tables Mapping Page Help

Error Lookup

This feature helps you to find the error message by its code for particular database engine.

Read More...

 Error Lookup

Forward Engineering

Taking existing databases with tables and other objects, and creating new diagram(s) is referred to as reverse engineering. You can create diagrams and add new tables, and link together with existed tables. You can save such diagrams.

  • You can draw totally new diagram(s) in empty database and save them to disk inside of this empty database.
  • FREE: You cannot ask Valentina Studio to produce SQL commands, which will create these new objects.
  • PRO: Buttons to generate SQL scripts are enabled. You can see that scripts. You can execute them against different databases. You can copy-paste them into your application code.

Read more about Forward Engineering Features...

Keyboard Shortcuts Modify

Keyboard shortcuts give fast access to most used actions of the Valentina Studio.

  • FREE: You can view and use default shortcut set.
  • PRO: You can modify shortcuts and create own sets of shortcuts.

Read more about the Keyboard Shortcuts...

Valentina Project (*.vsp)

Valentina Project file allows you organize different objects into a single project. In particular, Valentina Reports, JS Scripts, Queries, etc. These objects can be organized into a hierarchy of folders and you can see project tree.

Valentina Project file can be under Valentina Server to provide multi-user access to its items and jobs.

Report Editor

Report Editor is a very major feature of PRO version. Actually, it is part of Valentina Reports technology. Report Editor allows you to design reports visually.

  • FREE: You can design one and even few reports to play with, but they are not saved to disk. Valentina project file .vsp always will be empty.
  • PRO: You can save your job to disk.

Read also FAQ “Can I test before buy?” on this page.

Read more about the Report Editor...

Form Editor

Form Editor allows you to design input forms for your datasources visually.

  • FREE: You can design one and even few forms to play with, but they are not saved to disk. Valentina project file .vsp always will be empty.
  • PRO: You can save your job to disk.

Read more about the Form Editor...

JS/JavaScript

You can write JS scripts and keep them in a Valentina Project file.

Valentina Studio provides integration of JS-engine to GUI objects of QT classes, and to own DB-related objects/classes.

Query Editor

This feature allows you to build SQL queries visually, working directly with tables and links that are a part of the query you want to create. If you aren't a SQL pro, you will find this feature invaluable!

  • FREE: You can create SQL queries, but you cannot copy-paste them. So you still can get help from this tool, even in free version.
  • PRO: No limitations for copy-pasting the SQL query that you generate.

Read More...

SQL Builder Overview

Schema Editor

Drag and Drop of Objects

Drag and drop in the Schema Editor provide a simple visual mechanism which users can use to copy the schema objects within one database or even between different databases.

  • FREE: You can drag and drop the object one time after each start.
  • PRO: No limitations for copying the objects.

Read More...

Schema Cache

Valentina Studio loads structure of database objects and their properties on demand and store in the runtime cache. But the database structure usually doesn't change frequently as usual. This feature allows to store the schema cache and use when it is necessary.

  • FREE: Schema cache is removed when a database is closed.
  • PRO: Schema cache is saved in a file on disk, restored and used when the database is opened the next time which speeds up opening and navigation.

Read More...

Sub-Tree Expand/Collapse

In the Tree View of Schema Editor you can do Option/Alt click on item to expand/collapse all its sub-items.

Object Colors

Valentina Studio Pro allows you to mark objects with specific colors. You can specify a color for Connection/Db/Table. After this, all tools related to this object and its sub-objects will be colorized. This allows easy differing, for example, Deployment/Development databases.

Read More...

Schema Snapshot

Valentina Studio Pro allows you to save database schema in structured format using the Schema Snapshot tool

Read more about Schema Snapshot...

Schema Snapshot

Source Control

The Source Control feature of Valentina Studio Pro provides an ability of database development using any VCS.

Read more about Source Control...

Source Control

SQL DIFF

Compare schemas of two databases to find differences and produce SQL scripts that can transform the first schema into the second. Also, it is possible to apply changes directly to the first database.

  • FREE: You can see only the number of found differences for all Tables, Links, but you do not see details by each table, and you cannot save SQL scripts.
  • PRO: All features available! You see detailed differences, produce SQL scripts and apply changes to database(s).

Read more about SQL DIFF...

SQLDiff Help - Page with Results

SQL Search

SQL Search allows you to find database objects on a server or in local storage very quickly. Objects can be located either by name or by property value, according to the filter and selected matching pattern.

Read more about SQL Search...

SQLSearch

Create Dump Wizard

Creates a dump of the whole database or selected objects.

Read more about Create Dump Wizard abilities...

Search Field

  • PRO: Available usability improvement - filter for the list of database items, that will be dumped.

 Create Dump Wizard - objects filter