Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does anyone know of a good script for a beginner that:
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Does anyone know of a good script for a beginner that:
Divers
Thread ID:
00745290
Message ID:
00745290
Vues:
55
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform