I'm looking for a db script tool which can do the following:
- Create "create-scripts" for each table in the database and place them in separate files. Note: these files should not contain relational constraints.
- Create scripts for relational constraints (as one file or many, doesn't matter)
- Create insert scripts for populating tables.
We are going to put the scripts into tfs and they will be updated fairly often, so a tool which is fast and efficient to is highly preferred. I'm going to integrate these scripts into msbuild to create a database for our integration tests.