I am looking for options to get our extensive collection of database objects in many databases into source control (TFS 2010). As soon as we succeed here, we will work on creating our scripts to modify a specific DB using the TFS build.
The problem is that our data architecture group is responsible for maintaining database objects (excluding SP), and they work as part of the model process through ERWin. This means that they support the database through ERWin models and generate changes from them, which are used to release changes.
To achieve our goal of obtaining database objects (and not just ERWin models) in TFS, I believe that the best option is to do this through Visual Studio DB projects. From what I can say, there is very little time for CA to continue supporting integration between ERWin and Visual Studio, which no longer works with Visual Edge 2008 DB Ed. GDR. If I was misled in this regard, please do not be shy about me directly.
One possible solution is:
- Make changes to the ERWin model.
- Take the alter script generated from ERWin and import the script into the corresponding Visual Studio DB project by updating the objects in the DB project
- Check the modified objects in the DB project in TFS.
- TFS Build runs to create scripts that will be used to modify changes during the release process.
, ?