How to export SQL 2000 jobs,DTS jobs,alerts to SQl 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to export SQL 2000 jobs,DTS jobs,alerts...

How to export SQL 2000 jobs,DTS jobs,alerts to SQl 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Ram Prasad-868694

Posted Saturday, January 10, 2009 12:42 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 07, 2009 10:18 PM
Points: 13, Visits: 76

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

Post #634107

Jonathan Kehayias

Posted Sunday, January 11, 2009 5:26 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 16, 2010 10:13 AM
Points: 1,310, Visits: 1,228

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
http://www.sqlclr.net
http://sqlblog.com/blogs/jonathan_kehayias
http://www.twitter.com/SQLSarg

Post #634435

Steve Jones - Editor

Posted Sunday, January 11, 2009 8:47 PM

SSChampion

Group: Administrators
Last Login: Yesterday @ 8:26 PM
Points: 23,166, Visits: 6,925

You can right click the SQL Agent and script out a bunch of this stuff as well. Packages you have to move manually.

Post #634461

Ram Prasad-868694

Posted Sunday, January 11, 2009 9:59 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 07, 2009 10:18 PM
Points: 13, Visits: 76

Hi,
Can You please provide the steps how to export from 2000 & import in 2005
Please

Post #634467

Paresh Prajapati

Posted Sunday, January 11, 2009 11:37 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 11, 2010 3:37 AM
Points: 317, Visits: 412

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..

_____________________________________________________________________________________________________________
Paresh Prajapati

+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj

Post #634485

EdVassie

Posted Monday, January 19, 2009 5:06 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 7:29 AM
Points: 2,019, Visits: 1,653

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2005, 2008, and 2008 R2. 24 February 2010: now over 9,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #639201

« Prev Topic | Next Topic »

Permissions