Activity overview
Latest activity by pbz
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?
Version 8 broken...
Are you guys aware that version 8 of SQL Compare is not working as it should? I've tried it on a couple of databases and it failed on both (some SQL error). Version 7 had no problem in either case.
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 ...
Compare fails because of data
Here's a common scenario that I was hoping SQL Compare would be able to help, but so far no luck.
Let's say I have a table (A), let's call this version 1. After a while I add a new table (B) and ma...