Comments
Sort by recent activity
Emailed... / comments
Emailed...
OK, what do I need to do to send you guys the script / db? / comments
OK, what do I need to do to send you guys the script / db?
Michelle Taylor wrote:
Have you tried synchronizing with SQL Compare ignoring constraints, then synchronizing the data with Data Compare, then doing a second pass with SQL Compare synchronizing the constraints?
Maybe I didn't read that right, can you do that, and if so how? / comments
Michelle Taylor wrote:
Have you tried synchronizing with SQL Compare ignoring constraints, then synchronizing the data with Data Compare, then doing a second pass with SQL Compare synchronizing ...
Michelle Taylor wrote:
I'm not sure I quite understand the problem. Have you tried synchronizing with SQL Compare ignoring constraints, then synchronizing the data with Data Compare, then doing a second pass with SQL Compare synchronizing the constraints?
No, that's what I would have to do in order to get it to work. Right now, correct me if I'm wrong, since SQL Compare and SQL Data Compare are separate tools, I would have to run SQL Compare first to make v1 like v2. Doing this would create the new table B, but it will fail setting the referential integrity constraints because the data in table B is not there, therefore, the schema synchronization would fail. The data and schema go hand in hand, you can't separate the two in this scenario. So what's the solution for cases like this. / comments
Michelle Taylor wrote:
I'm not sure I quite understand the problem. Have you tried synchronizing with SQL Compare ignoring constraints, then synchronizing the data with Data Compare, then doing ...