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 5: Pivoting the table data for easier navigation
You can see that after pivoting the view, all of a single row’s data can be seen at one glance in a single vertical colum. In this case we can now see all the data associated with our Contact Mia Robinson in one screen. With very large tables, this is particularly useful.





