Description

Design business reports to run in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Backwards Engineering in Standard with Forward Engineering in Valentina Studio Pro.

Valentina Studio is your universal database management tool for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases. Valentina Studio lets you connect with all major databases, run queries and generate diagrams to better understand your mission critical business data - and that is the free version of Valentina Studio.

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.

SERVER ADMINISTRATION

Add/drop users, groups, manage privileges

Watch live logs, run diagnostics

Remotely Register/unregister databases

Create/Alter Schedule events

VALENTINA REPORTS

View Reports with parameters stored locally and registered on Valentina Server

Print Reports with parameters stored locally and registered on Valentina Server

Reports Designer available in Valentina Studio Pro

VALENTINA FORMS

Use local Valentina Forms to work with your data

Access Valentina Forms in projects registered on Valentina Server

Forms Designer available in Valentina Studio Pro

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

UTILITIES

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

REPORT DESIGNER

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 Report projects for Valentina Reports ADK applications

Deploy Report projects to Valentina Server

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

DATABASE CONTINUOUS INTEGRATION

Create | Save | Load database schema snapshots in structured format

Register | Commit | Increment database source control with any VCS

Generate Migrate scripts

FORMS EDITOR

Drag-create controls, widgets & layouts to create forms visually

Attach and write custom methods in jаvascript

Forms work work with any supported datasource including PostgreSQL, MySQL, MS SQL Server, SQLite and ValentinaDB

Upload Forms to Valentina Projects on Valentina Server

Deploy forms through free Valentina Studio on Windows, MacOS and Linux

QUERY BUILDER

Build SQL queries with just a few clicks and no code writing

Edit built queries in Data Editor and save to Snippets library

Copy your SQL queries to use in any application

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

Additional Information