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 |
|
ronaldrahme
Starting Member
3 Posts |
 Posted - 2008-06-27 : 05:30:40
|
| Hi all,i need your help guys, i have updated an old software in z company i work for and so i created a new database.. so i wanna script all the tables to the old database to migrate it with our clients database.. i dont have a problem with the new tables scripts where i used "drop, create, alter", but the thing is there exist some commun tables where i added new fields to them n some fields are with default values, i need a script to update the new tables with the old ones, any suggestions? i would really appreciate you help..10x in advance |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-27 : 06:08:40
|
| moved from script library which is meant for posting only working sql scripts.as for your question: can't you just create update statements between the 2 databases to update the data?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
ronaldrahme
Starting Member
3 Posts |
Posted - 2008-06-27 : 06:36:49
|
| no :( default values fields wont work.. this is the only problem i have |
|
|
|
|
|
|
Script