Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adnanans78
Starting Member
17 Posts |
 Posted - 2007-08-25 : 09:18:43
|
| Hi,I need support for the following problem.It is a teamwork.Suppose 25 databse developer developing a databse.every one make modification (update,delete,insert)to the centralized database.I want that every one its on database copy and make modification to that instead to centerlized database.As source control softwares do(e.g visual source safe).or any other way to manage database in such senerio.Hope any one will help.Thanx in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-25 : 10:40:57
|
| You can restrict access to centralized db. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-25 : 12:02:43
|
| You should check out Visual Studio .NET 2005 Team Edition for Database Professionals and Visual Studio .NET 2005 Team Foundation Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-26 : 09:56:48
|
| Thnx for reply,I will check such mantioned environments.But my question is that as visaul source safe work for script base format.I need thing which work form of tables not script.support developers make changes in its local copy of databse and then past that changes to the main data base.next time developers get all local copy in form of tables or mdb files.(as vss provides version base copies).or what happend if a large database is designed.how they control?Thnxs in advance. |
|
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-26 : 10:02:50
|
| Thnx for reply,I will check such mantioned environments.But my question is that as visaul source safe work for script base format.I need thing which work form of tables not script.support developers make changes in its local copy of databse and then past that changes to the main data base.next time developers get all local copy in form of tables or mdb files.(as vss provides version base copies).or what happend if a large database is designed.how they control?Thnxs in advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-26 : 11:31:55
|
| You just need to make sure you script the changes from the local copies and then those scripts need to be run on each of the copies plus main database. For schema versioning, you should check out the products I mentioned though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Database Management