SQL Server: Migrate Stored Procedures between Databases, Instances

Question

I just copied my current database to a new database to find out only the tables are copied, How do I copy all stored procs the same way in one go? I do not want to create each stored proc one by one again running create queries

Thank you in advance

This is in MS SQL

Please tag with product (SQL Server, mysql, Oracle, etc.). Most people won't be able to help you without this information. — Aaronaught
– Aaronaught, Commented Mar 18, 2010 at 15:21
Which version of SQL Server are you using? 2000? 2005? 2008? — Jim G.
– Jim G., Commented Mar 18, 2010 at 15:28

CResults · Accepted Answer · 2010-03-18 15:31:32Z

30

Use management studio
Right click on the name of your database
Select all tasks
Select generate scripts
Follow the wizard, opting to only script stored procedures
Take the script it generates and run it on your new database

answered Mar 18, 2010 at 15:31

CResults

5,1051 gold badge24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CResults Over a year ago

No problem. Can you tick my answer to show others it worked? :-)

zx485 · Accepted Answer · 2017-03-04 01:28:20Z

0

Please note that by using the migration wizard we can only convert tables and copy data,, but cannot convert the triggers, views and stored procedures.

We’ll have to do this manually, which we might cover in one of the future article on how to migrate MS SQL stored procedures to MySQL stored procedures.

Sorry if this is not the response desired....

edited Mar 4, 2017 at 1:28

zx485

29.1k28 gold badges55 silver badges65 bronze badges

answered Mar 3, 2017 at 23:53

qwqwe

1

Collectives™ on Stack Overflow

SQL Server: Migrate Stored Procedures between Databases, Instances

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related