from $395

($494 including support & upgrades)

  • Download 14-day free trial
  • Create a quote for SQL Data Compare
    • Purchase this now
    • Add SQL Data Compare Standard to shopping cart
    • Add SQL Data Compare Pro to shopping cart
SQL Data Compare box shot

SQL Data Compare

Walk-through 2: Performing a Row Level Restore

This walk-through will show you how to:

  • Compare with a backup
  • View the differences
  • Use the 'Pivot view' and the 'Find' box
  • View the Row Level SQL change script
Stop walk-through

Step 7: Restoring some data, ignoring the rest

Restoring some data

We want to update the test database with all the real email addresses and corrected phone numbers but we don't want to lose the 2 new records that are on the test database but missing from the backup. Simply uncheck the box relating to objects found only on the right-hand database. This ensures that any data unique to the right-hand side is left unchanged.

Back