Issues synchronizing to snapshot for tables with FKs
I have a nightly process that creates snapshots for developers to use to create DB change scripts for propduction. We have an issue where if a table is referenced by a Foreign Key, the synchronization script generated based on the snapshot does not see the dependency when trying to alter the PK on the child table, and so generates a synch script that fails. If I run the compare directly against the prod DB, it generates a script which works properly.
0 · Share on Twitter