Optillect Data Compare SQL 2456611.9375

• Analyse data difference in details
Many tools show the comparison result when all object pairs are done, but Data Compare SQL allows you to view row differences right after the comparison of a particular object pair is complete. In the result grid, which doesn't 'eat' memory and works fast whatever the number of rows, you'll see data for new, missing, different, and identical rows, where the differences are highlighted.

• Full data transfer or partial data synchronization
The result view is dotted with check-boxes that includes into (or excludes from) synchronization: objects; all rows found as source-only, different, target-only; any particular row.

• Generate T-SQL script to update target database
Data compare SQL has two options to update the target database: create a file with T-SQL synchronization script which you can execute any time you want, or update target database on-the-fly without consuming hard disk space for intermediate T-SQL script file.

• Generate INSERTs for all or particular data in tables
You can find special option 'Full data overwriting mode' which is designed to transfer data from one database to another with overwriting existing data. But it also allows to generate only INSERT statements for particular tables (and even for particular columns and rows!) by simply comparing a database with itself.

• Import settings from most popular tools
Yes, you can import project settings from one of the three most popular comparison tools. Why to configure everything from the very beginning, right?

• Ultra convenient and stylish user interface
We don't want to burden you with tons of manual pages, therefore we just added as much hints and tool tips as possible. We believe this will help you to start using our product right away.

• Lightweight software - 2.5 megabytes only
Our tool does not contain unnecessary code and resources, that's why it takes so little space!