SQL Compare doesn't seem to totally handle dependency
s_solt
Posts: 11
When I need to apply a huge number of schema changes to a target database, SQL Compare doesn't seem to follow a path which takes account of dependency.
I have a target (eg from MS Access) which has populated tables from which keys, indexes, triggers and views have been stripped (or not yet created). When I synch my development master to this I have to do tables first with keys turned off, then turn keys on, then turn views on, then turn triggers on, then do functions and finally stored procs. Whilst this isn't very demanding, I do feel that SQL compare should a bit cleverer at this bottom up approach. Even with depenencies turned on it doesn't seem to be able to do this reliably.
On the other hand, what it does it is an absolute godsend!
Stephen Solt
I have a target (eg from MS Access) which has populated tables from which keys, indexes, triggers and views have been stripped (or not yet created). When I synch my development master to this I have to do tables first with keys turned off, then turn keys on, then turn views on, then turn triggers on, then do functions and finally stored procs. Whilst this isn't very demanding, I do feel that SQL compare should a bit cleverer at this bottom up approach. Even with depenencies turned on it doesn't seem to be able to do this reliably.
On the other hand, what it does it is an absolute godsend!
Stephen Solt
Comments
From your post I suspect that you may have a linked server from your statement that begins "I have a target (eg from MS Access)".
Can you please confirm if you are a linked server?
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
SELECT * INTO [sqlTable] FROM [msdb]..[msTable]
I then attempt to apply all the other SQL objects and functionality from my master.
Surely you can't compare an SQL database to a linked Access Database!