Switch to: V9V8V7V6V5

SQLDiff Overview

Introduction

In v5.0 Valentina Studio Pro gets a new feature – SQL Difference. Using this feature you can compare schema of two databases.

SQLDiff is an excellent tool for database comparison, synchronization and versioning. It allows to browse differences in database objects and execute an automatically generated script to synchronize schemas. Also you can store the synchronization and rollback scripts for particular session. The user-friendly interface greatly simplifies discovering and eliminating differences in database structure saving your time and therefore money.

General Features
  • Support of all database engines powered by Valentina Studio
    • Valentina DB [Local and Server]
    • SQLIte local
    • SQLite on Valentina Server
    • PostgreSQL
    • SQL Server
    • MySQL
  • Comparing and synchronizing databases on different servers.
  • Ability to reuse comparison and deployment settings with SQLDiff project
  • Fast deployment - comparison and deployment in one click using SQLDiff project
Comparison options Features
  • Ability to determine particular object types for comparison.
  • Ability to determine particular object properties for comparison.
  • Ability to determine particular schemas for comparison (PostgreSQL and SQL Server)
  • Ability to determine the comparison key - Object Name or Object ID to figure out renamed objects.
  • Ability to determine renamed objects by creating custom objects map.
Difference browser Features
  • Visual representation of the differences between databases with details and modification scripts.
    • The tree of different objects
    • Groups of different objects by object type
    • Filtering synchronization actions by kind
    • Ability to browse synchronization and rollback scripts for the particular action
  • Built-in SQL Script editor with syntax highlight.
Deployment Features
  • Ability to synchronize databases in several modes.
  • Ability to use custom scripts in sycnroniztion process
  • Ability to store sycnroniztion and rollback scripts

Usage Cases

When this feature can be useful.

Scenario 1

WEB developer(s) develops the next step of web-app/site on localhost or development-server inside of office. Meanwhile production-server continue to work using vX. Job takes few days or even weeks. For this time developer(s) can add/update/drop quite many tables/links/procedures/…

TASK

Developer needs to update production server. So he need get scripts that do that for DB, or just RUN changes to apply changes.

SOLUTION

SQLDiff feature of Valentina Studio Pro.

Scenario 2

Application developer designs changes of db schema of version X using GUI tool – Valentina Studio to get version X+1. Job takes few days or even weeks. For this time developer(s) can add/update/drop quite many tables/links/procedures/…

TASK

Developer needs to update his REALbasic/VB/C#/… application code

  1. function that creates a new empty database
  2. function that migrates schema from vX to vX+1

SOLUTION

SQLDiff feature of Valentina Studio Pro.