Red Gate forums :: View topic - Using SQL Data Compare to augment or supplant TableDiff
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Using SQL Data Compare to augment or supplant TableDiff

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQLAdminCJ



Joined: 28 Dec 2011
Posts: 10

PostPosted: Wed Dec 28, 2011 2:57 am    Post subject: Using SQL Data Compare to augment or supplant TableDiff Reply with quote

Hello all,

I am currently trying out SQL Data Compare 9. I often have to manually resynchronize some data between our clients' servers when replication goes down. I use TableDiff, and, when it comes to comparing table differences, I compare the change scripts row by row, which is extremely tedious.

I have been using Data Compare 9 a little, and am pleased by the interface and the way it lines up rows from tables of two different databases by the primary key so that they values can be readily compared. What I'm wondering is if: I can read in the TableDiff scripts and have them lined up in this way via Data Compare or another Red Gate app to make them easier to compare.

Another thing is that I would rather not have to specify one database as a source and another as an object, and vice-versa. Moreover, the SQL Data Compare software will be on my computer, and not on the clients' servers, so I will need to take files such as those made by TableDiff back to a local computer to work on them.

Ideally, the program would show two rows, I would click on a row to add to the change script, and it would add the change script in that direction and not add it (or delete it) from the other direction. Does anyone know if SQL Data Compare 9 can do something like this? Or does anyone else have any suggestions on streamlining the resync process? I would greatly appreciate it.

Thanks.

2. I can
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Wed Dec 28, 2011 1:12 pm    Post subject: Reply with quote

Thanks for your post.
SQL Data Compare can't read in other files to show you the differences of unfortunately. You could use somthing like "Beyond Compare" (not a Red Gate product" to see the differences side-by-side but I don't think you could use it to build up a change script.

I wasn't quite sure what you meant in the latter part of your message - however in the upper half of the screen (where the list of tables rather than records is seen) you can tick the columns for "Source Only", "Target Only" and "Different".
This means you can get the change script to only insert records for instance, and not update any in the target and not delete any in the target. You'd achieve that by ticking just "Source Only".
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group