Script schema and data together – whether you need to transfer one table from one database to another or a whole database from one server to another the ability to script the schema of a table together with the data insert statements comes in very handy in certain situations. |
|
Compare only what you want to compare – xSQL Data Compare allows you to compare the contents of two whole databases, just the records in a few select tables, or just in one table. Furthermore, to avoid wasting time in comparing thousands or millions of records you may not care about, xSQL Data Compare allows you to compare just select rows within each table. |
|
Bulk insert for faster synchronization/transfer – while generating a few hundred or even thousands of insert statements may be ok in some cases when you need to move large number of records from one database / table to another that approach may not be practical. In those cases you can instruct xSQL Data Compare to generate bulk insert statements instead. |
|
Custom mapping between tables – tables have different names in the databases you are trying to compare? Not a problem, xSQL Data Compare allows you to map the tables you want to compare to each other regardless of their names. |
|
Define custom keys "on the fly" – need to compare tables but they are showing as non-comparable because there is no primary key defined? Once xSQL Data Compare has analyzed the schema it will allow you to define a unique key (any combination of the fields of that table) to use for comparison. |
|
Unattended comparison and synchronization – the included xSQL Data Compare Command Line utility that can be easily configured through the xSQL Data Compare interface allows you to schedule the comparison and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc. |
|
Compare and synchronize across servers, databases, versions – the databases to be compared (or tables within them) can be virtually anywhere – as long as you have access to them you can compare and synchronize them. Furthermore, the databases do not have to be of the same version or flavor – you can compare between any “flavors” of the SQL 2005 and SQL Server 2000 versions. |
|
Full control over the comparison and synchronization – a wide array of options gives you granular control over the behavior of the comparison engine. |
|
Improved handling of very large scripts – synchronization scripts may in cases reach millions of lines and would potentially bog down your system but xSQL Data Compare handles large scripts gracefully tightly controlling the amount of the resources consumed. |
|
Intelligent script execution - allows you to view the progress of the execution as well as safely interrupt the process if need be. |
|