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 |
|
learntsql
524 Posts |
 Posted - 2009-12-03 : 00:43:53
|
| Hi..I have dev,Test and Prod databases.I add some columns in Dev database How can apply/insert these columns to remaining database's respective tables.Can i generate script for only new columns and run it in other database. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-03 : 03:44:48
|
quote:
Originally posted by learntsql
Hi..I have dev,Test and Prod databases.I add some columns in Dev database How can apply/insert these columns to remaining database's respective tables.Can i generate script for only new columns and run it in other database.
It is not possibleIt is always better you do it via ALTER table... syntaxMadhivananFailing to plan is Planning to fail |
 |
|
|
creieru
Starting Member
12 Posts |
Posted - 2009-12-04 : 05:39:50
|
| or you can use tools like DBGhost... |
|
|
|
|
|
|
Script for newely added columns