Best Database Version Control method?

hi,

 i using tfs 2010 application , database version control. sql server read articles , using sql srcipts projects in sql server 2008 management studio. more difficulties in version control like

1. no sheling option available

2. sometime scripts not getting properly

3. someime same connections, scripts etc duplicating in solution explorer

4. team project multiple persons checkout database project , using. check-in time conflict came in solution file

how use better version control in database? other method? found visual studio 2008 project in visual studio templates. can use same thing? better sql server objects database in ssms?

or how can use exisitng 1 without issues specified?

hi akhilrajau,

thank post.

according description of issue, can create database projects in vs , put them under tfs version control.

to create database project can refer these articles: getting started database projects(http://msdn.microsoft.com/en-us/library/aa833257(vs.90).aspx) , how to: create database , server projects(http://msdn.microsoft.com/en-us/library/aa833235.aspx).

to put database projects under version control can refer these articles: walkthrough: put existing database schema under version control http://msdn.microsoft.com/en-us/library/aa833194(vs.90).aspx

you can first read these articles, provide useful information how put , manage database projects under version.

if unclear, please free feel let me know.

best regards,

lily wu [msft]
msdn community support | feedback us
get or request code sample microsoft
please remember mark replies answers if , unmark them if provide no help.

Archived Forums V  >  Team Foundation Server - General