General information
Forum:
Microsoft SQL Server
Category:
Database management
In addition to what Eric said, if you use a case tool like xCase or ErWin they will generate change scripts for you.
BOb
>maintains a target database to be updated to the current state of another source db?
>
>and handles the following:
>
>1)Check a source table to see if a table exists in target database, if it isn’t add it.
>2)In each table check to see if the column/field exists, and if not add it.
>3)Compare the column properties of the source against the installed version, and if there were changes, alter the destination.
>4)Clear and refresh all the stored procedures
>
>TIA
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only