SQL Server: Migrate Stored Procedures between Databases, Instances
sql-server, sql-server-2005
Solution
- 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
Problem
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