Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does anyone know of a good script for a beginner that:
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Does anyone know of a good script for a beginner that:
Miscellaneous
Thread ID:
00745290
Message ID:
00745290
Views:
54
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
Next
Reply
Map
View

Click here to load this message in the networking platform