Valentina Studio provides all the features of some commercial database management products at no cost. Valentina Studio Pro features provide advanced features and productivity tools, for data management, database design and reporting.

Compare Free Valentina Studio with Commercial Valentina Studio Pro

Features marked with a ✓ are fully enabled. Features marked with an "L" are limited in some way. All new features in the current, major release (7.x) are marked in green.

You should always evaluate Studio first to ensure Valentina Studio Pro is the right solution for you.

  Studio vs Studio Pro
Studio Pro Added

GENERAL

Operating System

Windows 32 & 64 bit versions 1.0
Linux 32 & 64 bit versions 2.0
macOS 64 version 1.0

Datasources

MS SQL Server 2000+ 6.5
MS Azure 6.5.10
MySQL 5.0.6+ 5.0
MariaDB 5.2
PostgreSQL 8.4+ 5.0
SQLite File 3.0.7+ 5.0
Valentina SQLite Server 3.0.7+ 5.0
Valentina DB File 2.X-5.X with Conversion 2.0
Valentina DB File 6.X + no conversion 6.0
Valentina DB Server 4.8
ODBC (Excel, Access, etc) 1.0

Database Continuous Integration

Schema Snapshot   7.0
SQLDIFF L 5.0
Source Control   7.0

Error Look Up

MS SQL Server 6.2
Valentina DB 6.2

SQL Search

Search via Open Connection | Bonjour | Bookmark   5.2.4
Search Filter Constructor   5.2.4
Advanced Pattern Matching   5.2.4
Result Object Browser   5.2.4
Result Path Browser   5.2.4
Open Found in Schema Editor   5.2.4

Utility

Data Transfer | ODBC Import   5.1
SSH / SSL Secure Connection 5.1
CLI Print Reports via Terminal or Script 6.4
SQLite DB to Valentina DB Converter 7.0
Valentina DB Diagnose | Clone | Compact | Defragment 6.0
SQLite DB Diagnose | Compact 6.0

Productivity

UI Toolbar | Tabs | Property Inspectors 2.0
Tooltips | Contextual Menus 2.0
Keyboard Shortcuts 2.0
Keyboard Shortcuts  Sets / Warnings   7.0
Import / Export Bookmarks (Connections) 2.0
Colorize Connection | Database | Table   7.4

SERVER MANAGEMENT

MySQL Server Administration

MySQL Add | Drop | Alter User 2.5.3
MySQL Server State 5.5
Disconnect User 2.5.3
Edit Server Parameters 5.5
View Logs 5.5

PostgreSQL Server Administration

PostgreSQL Add | Drop | Alter User 5.5
PostgreSQL Server State 5.5
Disconnect User 5.5
Edit Server Parameters 5.5
 View Logs 5.5
Notification Channels in Schema Editor 6.2
Domains in Schema Editor 6.3
User Defined Type (UDT) in Schema Editor 6.3

Valentina Server Administration

Valentina DB Server Add | Drop | Alter User 2.0
Valentina SQLite Server Add | Drop | Alter User 6.0
Valentina Server State 2.0
Disconnect User 2.0
Edit Server Parameters 2.0
Browse | Remove | Observe (TAIL) Server Log 2.0
View | Register | Unregister Database 2.0
View | Register | Unregister Project 2.0
Notification Channels (Schema Editor) 6.2

EDITORS

SQL Editor

Auto-complete objects and types 2.0
Auto-complete table aliases    
SQL formatting L 1.0
View Query Result 1.0
Edit Query Result, then Update Records    
Log | Output | Warnings | Tune Tabs 4.6
Export to Excel XLSX with Images   7.1

Data Editor

View | Create | Modify | Delete | Search | Sort Records 1.0
Related Table Editor Link Kind | Cardinality | Set | Mode 3.5
Text Extended Editor 1.0
Image Extended Editor 1.0
Preview  | Drag / Drop Images 2.1
Go to Parent Record 7.0
Data Editor Layouts L 7.0
Update Multiple Rows L 6.5
Set for All | Filtered Records   7.1
Edit Valentina DB KeyValue Data 7.1

Schema Editor & Diagramming

Tree | Column | Diagram View 5.0
Diagrams: Reverse Engineering 5.0
Diagrams: Forward Engineering (Generate Scripts)   5.0
Drag-create objects in & between databases L 5.0
Save / Restore Schema Cache   7.0
Import Diagrams from MySQL Workbench 7.3

Query Editor & Visual Query Builder

Drag Create Queries w Visual Builder L 2.4
Save / Copy+Paste Queries   2.4
Execute SQL / Display Results L 2.4
Open Query in SQL Editor L 2.4

PROJECT MANAGEMENT

Project Manager

Create | Edit | Share | Delete Local Project L 6.3
Create | Edit | Share | Delete Project on Valentina Server L 6.3
Create | Edit | Delete Datasource L  
Create | Edit | Delete Report L  
Create | Edit | Delete Resource L  
Create | Edit | Delete | Execute | Log Script L  

Report Viewer

Export Reports to PDF 6.3
Export Reports to HTML 6.3
Print Reports to Local Printer 6.3
Print Reports via Valentina Server attached Printer 6.3

Reports Editor

Report Visual Designer L 4.0
Visual Drag | Drop Controls & Fields Tabs L 4.0
Report Parameters L 7.0
Report Profiling for Region Splitting L 6.5.3
Save Report to Disk   4.0
Create / Run / Log Script - Javascript 7.0
Create / Run / Log Script - SQL 7.0
Conditional Formatting 4.2