Switch to: V12V11V10V9V8V7V6V5

SQLDiff Overview

Introduction

SQLDiff is an excellent tool for database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of databases and eliminate all or selected differences. Having SQLDiff you can define comparison parameters and save difference script. Its user-friendly interface greatly simplifies discovering and eliminating differences in database structure saving your time and therefore money.

Key Features:

  • Comparing and synchronizing databases on different servers.
  • Comparing of all database objects or selected ones only. Comparing by all or selected properties of objects only.
  • Ability to recognize the renamed objects.
  • Visual representation of the differences between databases with details and modification scripts for different objects.
  • Ability to synchronize databases manually step by step or automatically.
  • A wide variety of options for comparison and synchronization.
  • Built-in SQL Script editor with syntax highlight.

Description

In v5.0 Valentina Studio Pro gets a new feature – SQL Difference. Using this feature you can compare visually schema of two databases. It works for all supported databases: Valentina DB (local and under VServer), SQLite, mySQL and PostgreSQL.

Using SQLDiff of Valentina Studio you can:

  • specify source and destination databases
  • get list of all differences grouped by kind of Schema object.
  • monitor each changed object to see its SQL command before/after change and ALTER command that change object from BEFORE to AFTER state.
  • by mouse click select/unselect a difference to include/exclude it from final script.
  • generate script of SQL alter commands that can be applied to the SOURCE database to move its schema into DESTINATION state.
  • just click RUN button to apply selected differences to SOURCE database.

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.