We are currently using DBGhost with our SQL server database. The current version control tool is VSS along with which we are using DBGhost. Now, we want to migrate to TFS and have some questions about using DBGhost with TFS.
- Can DBGhost work with TFS?
If yes, what kind of output it expects from TFS?
a. Just the checked in database file (table, stored procedure .sql files etc.) same as VSS
b. OR It needs TFS to run a build after the files are checked in and then DBGhost looks at the results of the Build?
What I meant to ask is, for using DB Ghost with TFS, is it okay to put all the code from VSS into TFS just like that OR it should be first converted to a Visual Studio Database Solution using SSDT and then put into TFS and then define Builds in TFS that would run after every checkin?