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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-02 : 08:51:00
|
| Arjang writes "Hi As a developer I work on a development Database, and after adding fields to tables, altering SP's , Adding new tables etc. I need to apply the same exact changes to production database.So far I have been doing this manually, but is it possible to get the list of all alteration from some date onwards as Sql Scripts and run them on the Production server?Of course doing the alterations in Sql and keeping them in a file might seem like a solution , but it is a tedious process prone to human error.Is it possible to turn on some database reporting feature that keeps track of modification's applied ?Is there another way of visioning database structures and applying them?Thanks" |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-03-02 : 09:14:45
|
| Look at a third party tool such as Innovartis DBGhost [url]http://www.innovartis.co.uk/products/products.aspx[/url] or Red Gate SQL Compare [url]http://www.redgate.com/[/url]. Visual Studio 2005 Team Edition for Database Developers also has this kind of functionality. You could, in theory, use DDL triggers for this, but I imagine it would be pretty laborious. Don't discount the file based approach. If you keep all the scripts under source control and are strict about not circumventing it (i.e. just going into the db and making changes), this approach can work really well, and obviously makes it very easy to see change over time.Mark |
 |
|
|
|
|
|
SqlServer2005 Database structure Alterations List