Copy stored procedures from one Database to another in SQL Server

Question

hii have two databases database1 has stored proceduresi want to copy all stored procedures  from database1 to database2 in sqlseverplease help to do thisThanks and Regardscywa

dharmendr · Accepted Answer

Hi cywaRight click on databaseTasksGenerate Scripts gt NextCheck specific database objects RadioButtonCheck Stored Procedures checkbox gt NextCheck Save to File RadioButton and pass path to save the file gt Next gt Next gt FinishOpen the script and change the USE TargetDataBase statement and Run generated scripts against in target databaseThats all

Copy stored procedures from one Database to another in SQL Server

Company

Explore

Follow us

Contact Us