Examples Using the Command Line

See Also

This topic provides some simple examples of how to use the command line interface.

For detailed examples of how to include specific tables, see the following topics:

• Selecting Single Tables for Comparison
• Selecting Tables with Unrelated Names

You may also wish to refer to Frequently Asked Questions for the Command Line.

Comparing and synchronizing database data

To compare the data in WidgetDev and WidgetLive:

sqldatacompare /database1:WidgetDev /database2:WidgetLive

To compare the data in WidgetDev with WidgetLive, and synchronize the databases by updating WidgetLive:

sqldatacompare /database1:WidgetDev /database2:WidgetLive /synchronize

To compare the data in WidgetDev and WidgetLive, specifying the comparison key for the Widgets table explicitly to be PK_Widgets:

sqldatacompare /database1:WidgetDev /database2:WidgetLive

               /comparisonkeys:Widgets:PK_Widgets

Note that you can specify a primary key or a unique index as the comparison key when you use the command line interface.

To synchronize data in WidgetDev and WidgetLive, specifying that for table WidgetPrices only columns RecordID, Price, and Active are to be migrated:

sqldatacompare /database1:WidgetDev /database2:WidgetLive

               /columns:WidgetPrices:RecordID,Price,Active

 

 

 

---

© Red Gate Software Ltd 2007. All Rights Reserved.