How to migrate ALL Jobs to another server at one ?
-
I want to migrate ALL jobs at my development server to my new production server. The total of jobs more than 50. If I generate SQL Scripts one-by-one, it need a lot of time.
Is there anyway, I can generate all jobs into one scripts text file and independent enough to execute it at any server (not depending to the server name, but same version of SQL Server).
Thank you in advance....
Regards,
kokyan
Regards,
kokyan 
-
You could backup the msdb database on your development server and restore it on your production server.
There's something in the script library that claims to script all jobs at once, though I haven't tried it. Here's the link:
http://www.sqlservercentral.com/scripts/contributions/379.asp
Greg
-
In Enterprise Manager go to the Jobs node and right click it. Select "All Tasks/Generate Sql Script" and go to town.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB EngineerThis posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
-
I'd script from EM.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
Thanks gljjr. I test your method out and it works. I rather use this method comparing to backup MSDB database and restore to production server because the production server also reside other db as well.
Regards,
kokyan
Regards, kokyan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply