Activity overview
Latest activity by Patrik
Thanx for the fast answer. I have been away on vacation and I haven't the time to check this right now but will do it in a couple of weeks. (Heavy mailbox [image] )
Cheers! / comments
Thanx for the fast answer. I have been away on vacation and I haven't the time to check this right now but will do it in a couple of weeks. (Heavy mailbox )
Cheers!
Hi Brian!
I have updated to the latest version but that was not really the reason the db sync didn't work the first time. I had to run sync a few times with different settings. First with the ignore FK, to create the missing tables and then with FK to add colums and references to the tables already existing.
It doesn't seems like SQL Compare can handle the scenario with new tables and references to existing one's. (or it's me not using the right settings :-))
Cheers!
// Patrik / comments
Hi Brian!
I have updated to the latest version but that was not really the reason the db sync didn't work the first time. I had to run sync a few times with different settings. First with the ignor...
Sync db with new FK --> catch 22?
Hi!
I use SQL Compare (3.2.0.5) to sync a development DB to a test DB. When the development DB schema has foreign key changes the sync script will throw an exception. This is really easy to reprodu...