Featured Products
Omegabundle for Xojo Web Mini 2018 Products

Valentina Studio Pro 8 is the professional SQL database administration and reports generation software available on macOS, Windows and Linux.

Check out what is new in Valentina Studio Pro 8. If you got Omegabundle for Xojo 2018 during the summer, upgrade instead to Valentina Studio Pro UNIVERSAL.

 Valentina Studio Pro 8

Valentina Studio Pro brings together the best database administration and design tool along with a powerful, visual Report Designer for use with Valentina Reports ADK for Xojo and Valentina Server.

Report Designer & Report Viewer

  • Visual design layout tools turn queries into reports; live preview
  • Toolbox of controls, html, barcodes, charts, graphs and more
  • Sub-reports, regions, groups
  • Easy add macros, expressions
  • Print to all standard paper formats, set gutter, margin, max records per page

 

  • Deploy Reports (in projects) Valentina Reports ADK for Xojo
  • Deploy Reports (in projects) on Valentina Server
  • Deploy Reports (in projects) to users of free Valentina Studio

Visual Form Editor & Form Deployment

  • Flexible layout editor for designing forms for ease of use
  • Large palette of database controls (combo box, spin box, check box, text, image, table view, sub forms, etc) and visual controls (buttons, boxes, lists, image, lines, etc)
  • Sub-reports, regions, groups
  • Easy add macros, expressions
  • Print to all standard paper formats, set gutter, margin, max records per page

 

  • Deploy Forms (in projects) to users of free Valentina Studio
  • Deploy Forms (in projects) on Valentina Server

Schema Editing & Diagramming

  • Manage multiple databases in tabs and dockable views
  • Create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views, Stored Procedures, Properties, Sequences, Types, ...
  • Edit properties of multiple objects at the same time
  • Drill down to tables and fields; incredible fast searching
  • Reverse engineering and create diagrams for existing databases. Add new objects to diagrams.

Query Builder

  • Build SQL queries with just a few clicks and no code writing
  • Copy your SQL queries to use in any application

SQL Editing

  • Write SQL queries with auto-completion, color syntax
  • Define, manage, save favorite queries; access recent queries
  • Function browser dictionary of each function
  • Consoles for errors, warnings, performance
  • Search, Export result records into CSV, JSON, Excel

Forward Engineering

  • Visual Diagram Editor generates new databases
  • Toolbox of controls, labels, comments, procedures, tables, views
  • Generate scripts, copy scripts into your app code
  • Easy visual navigation of very large diagrams

Server Administration

  • Add/drop users, groups, manage privileges
  • Watch live logs, run diagnostics
  • Remotely Register/unregister databases
  • Create/Alter Schedule events
  • Register / Unregister Valentina Projects

SQL DIFF

  • See all the details of differences in Tables, Links and more
  • Generate scripts to execute to modify databases

Data Transfer

  • Copy records between two different databases
  • Specify mapping of source/target Tables and Fields
  • Log details and observe the transfer and result

Utilities

  • Diagnose, compress, clone, defragment, reindex and dump data
   

 

What's New in Valentina Studio Pro 8

Valentina Studio Pro 8 series introduces Valentina Forms, new scripting options for Reporting, a revised and vastly improved SQL Editor, better diagramming features and many productivity improvements, including:

  • Valentina Forms. Design forms then deploy them to Valentina Studio (including Free Version) and Valentina Server; Supports all Valentina Studio Data Sources, VIEWS & Queries as Data Sources; Sub-Forms
  • JavaScript Editor. Utilized primarily by Valentina Forms, also includes Auto-Complete
  • Forms Generate Reports. VReport and VProject allows generation of Valentina Reports using JavaScript
  • Array Editor. ValentinaDB now includes an Arrays Type
  • Schema Snapshot Improvements. Improved PostgreSQL support; named objects
  • Reports Backgrounds. Now controllable by Script
  • Reports Conditional Styles. 'Equal To', 'Less Than' and 'Greater Than'
  • Reports Last Page Footer. Now you can designate a special footer that appears only on the Last Page of your Report
  • Reports Control Conversion. Convert control types after creation
  • Reports Printing Improvements. More control over default parameters for printing reports
  • SQL Export Progress Dialog. Know how far along export takes; allows canceling long exports
  • SQL Editor Export to Excel Improvements. Better results when exporting directly to to a spreadsheet
  • SQL Editor Advanced Command Editor. New commands for editing complex code, command buttons
  • SQL Editor Add Multiple Objects. Drag objects to display panel for adding into SQL code
  • SQL Editor Parameters Editor. Interactive panel for working with parameters.
  • SQL Editor Improved Find / Replace. More productive methods to find and replace within your code
  • SQL Editor Flag Unresolved. Underline unresolved objects when copied into the edit area
  • SQL Editor "From Code" Clean Up. Button cleans up and formats code copied into the edit area
  • SQL Editor Execute Current. Button executes only the selected code in the edit area
  • Data Editor Copy-Paste from Excel. You can now paste Excel data directly into the Data Editor table
  • Diagram Editor Show | Hide FK. Display FK database relations
  • Diagram Editor Add All Tables. Add all existing tables to a diagram easily
  • Diagram Editor Add Multiple Objects. Now you can add multiple, different objects to your diagram all at once

Valentina Studio Pro is available for Windows, Mac OS X and Linux. Your order of Omegabundle for Xojo includes your choice of one operating system version.

All Major Databases Supported by Valentina Studio

You can work with all major databases, including:

  • MS SQL Server & Microsoft Azure SQL DB
  • MySQL
  • PostgreSQL
  • SQLite (including Valentina SQLite Server!)
  • MariaDB
  • Valentina DB

 


Data Modeling

Model databases visually with the premier Database Schema Editor reverse and forward engineering tool. Generate diagrams automatically from existing databases. Add new elements visually with PRO.

Data Modeling with Database Diagram Editor


Visual Report Builder

Transforms queries into visually stunning enterprise reports with full suite of design elements: charts, graphs, barcodes, grids, images, html objects, labels, text boxes and more. Reports are saved into Valentina Projects.

Visual Database Report Builder


Query Builder

Build SQL queries visually with Query Builder. Work directly with tables and links that are a part of the query you want to create. Copy-Paste your generated queries with PRO.

Database Visual Query Builder


Data Transfer

Copy records between two different databases. This feature is different from simply importing data. Use Data Transfer to choose one database as a Source. Then choose another database to be the target database. You can then specify mapping of source/target tables and fields and load records from db1 to db2.

Data Transfer from Database A to Database B


SQL DIFF

Compare schemas of two databases and produce SQL scripts that can transform the first schema into the second. Apply changes directly to the first database.

Visual SQL DIFF for your databases


System Requirements

These are the Valentina Studio System Requirements for Valentina Studio 6 or later.

Windows

  • Win Vista SP2+;
    Win 7 SP1+; Windows 8; Windows 10
  • HD 20 MB+; RAM 50 MB
    (dependent on database size)

Linux

  • Ubuntu 10.0.4 +, Centos 5.0+, Debian oldstable+,
    Fedora 10+, openSuse 11+ RHEL 5+
  • HD 20 MB+; RAM 50 MB
    (dependent on database size)

Mac OS X

  • Mac OS X 10.7+ Intel
  • HD 20 MB+; RAM 50 MB
    (dependent on database size)