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 - 2001-02-06 : 15:44:10
|
rajiv writes "I made database which i had to install at different locations.
The database was not online.
I have to make few changes in the database at a particular location viz.
added new tables,
added new columns to the existing tables,
changed the datatype of certain columns of existing tables,
renamed few columns of existing tables,
deleted few columns from existing tables.
The databse was such a large that it was very difficult for me to remember all the changes made at a particular location which were to be incorporated similarly in the databases at other locations.
I need to make a function that will compare the upgraded database with the older version of the database and make the updations to the older version of the database accordingly without having any affect on the data of the databases i.e.,it should affect only the structure.
The databases are in SQL Server7.0
Pls tell the suggestion." |
|
|
|
|
|
Database structure replica