Synchronizing only selected fields

hnteknikhnteknik Posts: 3
edited December 9, 2009 4:20AM in SQL Data Compare Previous Versions
I have to repair a damaged table with relatively old backups.
Only a couple of the fields need to be updated leaving other fields unchanged. Can that be done with data compare ?
· Share on Twitter

Comments

  • peter.peartpeter.peart Posts: 364
    Hi there,

    Providing you have the PRO edition of SQL Data Compare and it is full or differential backups that you are comparing against, SQL Data Compare shouldn't have a problem with this at all.

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
    · Share on Twitter
  • hnteknikhnteknik Posts: 3
    How do I select/deselect fields. Rows can be deselected but can't see where to deselect fields ?
    · Share on Twitter
  • peter.peartpeter.peart Posts: 364
    Hi,

    If you know the data in the specific field then you can run a WHERE clause, alternatively select the row you know where the field is to drill down to that, and then when you rum the synchronization wizard only the fields that are different / or you manually specify from there will be selected for synchronization.

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
    · Share on Twitter
Sign In or Register to comment.