Generic script to copy all stored procs only

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Generic script to copy all stored procs only

Author

Topic

anurag_batra
Starting Member

1 Post

Posted - 2008-11-03 : 13:38:44

I have a QA database for Stored Procs and Functions and I have a master database withe live data in it along with probably older version of Stored procs and functions.

I want to create a scheduled job that would run everyday and copy only the stored procedures and functions from QA to Production environment. The data in PROD should NOT be touched. Is there a generic script that can do that?

Thank you in Advance.

Regards,
Anurag

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-03 : 14:07:09

quote:
Originally posted by anurag_batra

I have a QA database for Stored Procs and Functions and I have a master database withe live data in it along with probably older version of Stored procs and functions.

I want to create a scheduled job that would run everyday and copy only the stored procedures and functions from QA to Production environment. The data in PROD should NOT be touched. Is there a generic script that can do that?

Thank you in Advance.

Regards,
Anurag

I think it is better to do manually rather than using jobs to automate so you don't mess up production. You can use Transfer object task in SSIS or Generate script to do whatever you need to do