Copy database changes without data

Hi,

This requirement is for our development and test environment. We have a database server which we use for development hence many changes are done on the database objects on daily basis like tables def changes, view def changes, sp changes, new sp etc.

On the other hand our testing team connects to another database server where they perform testing hence any internal test release would need the changes like tables def changes, view def changes, sp changes, new sp etc.

Since testing team already have their test data set in the test environment hence they want to keep their data but new test release should only provide with datbase object changes. The difficult part is, we have over 500 tables and about 1000 views and somewhere about 400 stored procs, so its not possible to manually perform the above task.

I dont do database admin job hence clueless as what would be the best way to accomplish the above. Pl advice.

we are using sql server 2005 on both test and dev environemts.

cheers!
d2

Check out SQL Compare from RedGate.

http://www.red-gate.com/

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Check out Visual Studio Team Suite for Database Professionals

http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx

|||Hi Vishal,

Thanks for your response.

We have license for team system but we are not using visual studio for database professionals as yet. Could you pl point me to some good tutorial on this subject.

thanks,
d2
|||

http://msdn2.microsoft.com/en-us/teamsystem/aa718764.aspx

|||i tested SQL Compare [www.red-gate.com] with SQL Server 2005. it is very good tool and it enables you to synchronize changes on DB Schema.|||I have used the VSTS for Database Professionals tool as we have VSTS licenses. It works like a charm.

Thanks for all the advises.