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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-04 : 08:07:56
|
| Lars writes "Hello!How can I script a database with alter instead of Create? Is this possible?I have four different databases - that should be maintained. How can I do that? I was thnking of running a DTS - but How do I do that?Running SQL2k Dev Ed and XP Prof" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-04 : 08:21:29
|
| Do you mean you want to generate a script to update the schema in one database to match another?You woud have to code that yoyurself or get a product like sqlcompare.==========================================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. |
 |
|
|
|
|
|
ALTER TABLE Script (maintainance)