Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy Stored Procs from database to another?
Message
 
À
18/04/2008 00:31:03
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01311618
Message ID:
01311637
Vues:
16
>How can I copy a group of (or all) stored procs from SQL Server database to another?

You can do this via SQL Server Management Studio. Right-click on the Database, select Tasks, then Generate Scripts. A wizard will open, select the database, hit next, select whatever options you want, click next and check the option to just generate Stored Procs. Select the procs. you want (or all of them), and save it. Then rerun this script on your other database.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform