Hi all,
I am planning on doing a database deployment script for sql server 2005.
Currently we have a tool that will run all of the tables, foreign keys, indexes and then data, each of which is located in a separate file with a certain extension (eg. tab, .kci, .fky) and the tool just runs *.tab, *.kci, *.fky into the db etc.
Could I possibly combine all of thse into one file and have them run ignoring referential integrity until they are all complete, I would turn it on before we started inserting test data.
It is just unmanageable having to maintain 4 or 5 different types of scripts for one table.
Are there any issues I should be aware of?
Cheers