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.
2. I can