Hi,
Could someone point me in the right direction? I have an internal development database and a production database. Is there an easy way to replicate the changes that have been made to the development version on the production server without modifying the actual data in the tables? So, if I add a new user in my development version I offcourse don't want to see it pop up in the live version. But adding/deleting/updating a new table or column should.
And if possible I'd also like to know how you could do the following: Let's say we have an OrderDetail table containing information about the purchased product. Let's say I'd like to add a new column 'total' to skip calculation on the database every time I want to know the totals. It should be able to initialise the value by doing 'times ordered * price' for every existing row. Is that possible as well?
Srry for the noob questions 
edit: Using MSSQL 2005
There are tools like Red-Gate Compare and Visual Studio for Database Professionals that might be helpful for this situation.
Check out "Computed Columns" in the Books Online.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||http://www.red-gate.com/And ApexSQL has a tool for this too, I believe.
http://www.apexsql.com/sql_tools_script.asp
HTH...
Joe|||
Also, check out Visual Studio 2005 Team Edition for Database Professionals.
http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx
