Tuesday, October 9, 2007

DTS (Database & Team Foundation Sidekick)

I decided to make this tool to help with the database management in Team Foundation Server. There is a massive gap between TFS and SQL Server Management Studio. SSMS can communicate with TFS but the SSMS environment is so limited.

Current features of this tool:
- Generate Scripts from SQL Server 2000/2005 in SQL 2000 format.
i.e. If exists then Drop then Create.
- Save output to file.
- Save output to TFS
- Find changes from TFS in a defined folder.

Future features:
- Compare 2 different databases and script the changes into TFS
- Compare lookup data of 2 different databases and script the changes.

You can download it from here.

You will need the Visual Studio SDK 2005 installed.

No comments: