Packaging db with constraints?
Brian Donahue
Posts: 6,590 Bronze 1
Hi,
SQL Packager does an excellent job of putting the schema in the right order by looking at all of the object's DDL and parsing it for dependent objects.
The data scripts are much simpler about populating the table data though. The data scripts will set IDENTITY INSERTs on for the duration of the transaction so that the row identifiers will match the original, but in some cases you'll need to decide for yourself if you want to use data options like disabling triggers or foreign keys.
SQL Packager does an excellent job of putting the schema in the right order by looking at all of the object's DDL and parsing it for dependent objects.
The data scripts are much simpler about populating the table data though. The data scripts will set IDENTITY INSERTs on for the duration of the transaction so that the row identifiers will match the original, but in some cases you'll need to decide for yourself if you want to use data options like disabling triggers or foreign keys.
This discussion has been closed.
