Packaging db with constraints?
Brian Donahue
Posts: 6,590 Bronze 1
Hi,
SQL Packager is really good at scripting the database in dependency order to make sure that the scripts will not fail.
It doesn't do much on the data side, aside from setting IDENTITY INSERTs on to retain the ID of records from the source database.
For anything else, you may need to set the Data options such as disabling foriegn keys and triggers to preserve the data integrity. It depends on how the database is designed, but the flexibility is there for you.
SQL Packager is really good at scripting the database in dependency order to make sure that the scripts will not fail.
It doesn't do much on the data side, aside from setting IDENTITY INSERTs on to retain the ID of records from the source database.
For anything else, you may need to set the Data options such as disabling foriegn keys and triggers to preserve the data integrity. It depends on how the database is designed, but the flexibility is there for you.
This discussion has been closed.
