Migrating SQL Jobs from SQL 2005 to SQL 2012

  • This week we migrated from SQL Server 2005 to SQL Server 2012. I just looked in SSMS 2012 and found none of our SQL Jobs there. How do I migrate them? Do I generate their SQL scripts and do it that way?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Right click on the SQL Agent jobs in SQL05, script job as, create, to new query window. Run that script on the SQL12 instance and you jobs will get re-created.

    MCSE SQL Server 2012\2014\2016

  • Thank you!

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Rod at work (10/8/2013)


    Thank you!

    You are Welcome

    MCSE SQL Server 2012\2014\2016

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply