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 |
|
Avinash Patil
Starting Member
1 Post |
 Posted - 2005-02-10 : 05:51:04
|
| Hi, I am in big problem. I am working on some tables (offshore), in which I hv added two columns and made them composite key with already exist primary keys and build up some constraint with other tables. Now I want to add these tables (which are changed) into live database. but problem is that there are lots of table changes which I cant script out manually. another problem is if live database has different structure than my database (as new 2 columns are added ) then how can i update/execute my scripts so the live data would be consistant ? Please help me out. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-10 : 14:42:53
|
| Not sure what you want to do.If you want to script the live system so that you have something to work on then enterprise managerorhttp://www.mindsdoor.net/DMO/DMOScriptAllDatabases.htmlwill do it.You might also get useful output from http://www.red-gate.com/SQL_Compare.htmYou can still run alter table scripts to add the columns.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Generating scripts.