Activity overview
Latest activity by jfleming
Yers, I am using a snapshot generated by RedGate SQL Compare 8.2.
I can use the snapshot to generate a database with no differences at all. I then do a compare against a scripts folder. If I use the DB I created from the snapshot, it finds all the dependencies and everything works. If I use the snapshot itself, however, it fails to find the dependency between the PK and the FK, and generates a script that fails. I will e-mail with the items in question, since it's a lot of scripts and tables for my snapshot. / comments
Yers, I am using a snapshot generated by RedGate SQL Compare 8.2.
I can use the snapshot to generate a database with no differences at all. I then do a compare against a scripts folder. If I use ...
Yers, I am using a snapshot generated by RedGate SQL Compare 8.2.
I can use the snapshot to generate a database with no differences at all. I then do a compare against a scripts folder. If I use the DB I created from the snapshot, it finds all the dependencies and everything works. If I use the snapshot itself, however, it fails to find the dependency between the PK and the FK, and generates a script that fails. I will e-mail with the items in question, since it's a lot of scripts and tables for my snapshot. / comments
Yers, I am using a snapshot generated by RedGate SQL Compare 8.2.
I can use the snapshot to generate a database with no differences at all. I then do a compare against a scripts folder. If I use ...
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 synchroniza...