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 - 2002-02-08 : 10:46:11
|
| Darek writes "I am seeking program which allow create script with differences between 2 databases, which can I use to create upgrade from old version of database to new version.When in new version of database was added new column to table "my_table", upgrade script will look ... :ALTER TABLE my_table ADD new_column VARCHAR(20) NULL" |
|
|
DGMelkin
Starting Member
24 Posts |
Posted - 2002-02-08 : 17:51:56
|
| Assuming it's still out there, Embaracadero has DBArtisan Change Manager, which will run compares between the databases and then you can save the scripts or run them right then and there. ERwin also has similar capabilities, but it's more complicated; one of the databases should be in the model and then you can do your compare and script changes that way. There are a couple of others out there as well. But these are the 2 that I've worked with.-D |
 |
|
|
|
|
|
Upgrade script