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.
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!
d2D2
Visit at http://www.red-gate.com/products/SQL_Compare/index.htm
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> 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.
> 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
>|||* D2 wrote, On 30-7-2007 10:36:
> 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.
> 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
>
If you're using Visual Studio Team System, have a look at the new
Database professional add-in for the suite.
http://msdn2.microsoft.com/en-us/te...m/aa718807.aspx
I can also heartily recommend Red-gate SQL Compare, I've used that
product many times before with great results:
http://www.red-gate.com/products/SQL_Compare/index.htm
Jesse|||I like xsql. http://www.xsqlsoftware.com/Main.aspx
They have an sdk which is very handy for custom applications.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> 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.
> 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
>|||I recommend ApexSQL Diff. http://www.apexsql.com/sql_tools_diff.asp
TheSQLGuru
President
Indicium Resources, Inc.
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> 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.
> 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
>