January 10, 2009 at 12:42 am
Hi,
I want o export all sql 2000 jobs, DTS jobs to SQL 2005 & i want toexport SQL 2005 jobs to another SQL 2005 server.Please guide us.
Thank You
Ram Prasad
January 11, 2009 at 5:26 pm
You can use the DTS Migration wizard to move to 2005. You can also save packages to the file system from both DTS and SSIS and then import them into SSIS from the file system.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 11, 2009 at 8:47 pm
You can right click the SQL Agent and script out a bunch of this stuff as well. Packages you have to move manually.
January 11, 2009 at 9:59 pm
Hi,
Can You please provide the steps how to export from 2000 & import in 2005
Please
January 11, 2009 at 11:37 pm
Ram Prasad (1/10/2009)
Hi,I want o export all sql 2000 jobs, DTS jobs to SQL 2005 & i want toexport SQL 2005 jobs to another SQL 2005 server.Please guide us.
Thank You
Ram Prasad
U have to generate script jobs and alerts from generate script option.
and for DTS u havr save it to disk and import in to sql server 2005..
January 19, 2009 at 5:06 am
SQL Server FineBuild has a load of scripts you can use for this export and import. Feel free to raid the code for anything you need.
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 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply