November 10, 2008 at 2:41 am
Hello to all,
I would like to know, which is the best way, to migrate de Jobs i have in SQL Server 2000 , to my new database in SQL Server 2005...
Thanks
November 10, 2008 at 3:06 am
Hello,
If you don’t already have them saved as Scripts, then I would script them from Enterprise Manager (it allows you to script all local jobs in one go) and run them in SSMS.
The following thread includes a SQL DMO script that you could use as an alternative e.g. if you have many servers to migrate.
http://www.developersdex.com/sql/message.asp?p=580&r=6397798
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
November 10, 2008 at 4:11 am
see the below link to help you:
http://msdn.microsoft.com/en-us/library/ms191450(SQL.90).aspx
November 11, 2008 at 3:43 am
SQLServerFineBuild contains SPs to script out SQL Agent jobs and scripts to reload them. It also has SPs to script table, views, SPs, Users, etc. Even if you do not want to use FineBuild to install SQL, you can raid the code for useful SPs.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply