Auto genarate script to alter table

[hlybbi]

is thera a way to make sql autogenerate script to alter tables

i have 2 db one desing db for my program and one db for the accual online program , and when i have alter the desing db i would like to run a script that alters the db witch is in use, with out destroing all the data that exist on that db.

Best regards Hlynur

http://www.xodus.net

 

[hmckillop]

Have you had a look at the SQL compare software.

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

"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLSister]

Absolutely - go for SQL Compare. It will be some of the best money you ever spend. ANd it's not terribly expensive either. YOu can compare two databases to see what is differnt and then select exactly what items you want make the same on the second database. You do need to be careful how you do this as the scripts will rollback all the transactions if one fails and so you need to do objects that other objects depend on first. Usually I do table changes first, then views, then UDFs then sps. Sometimes I have to break it down a bit further if I have a table change dependant on another table change which must happen first.

Questions about posting. See faq183-874