SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    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 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Ram Prasad-868694
Posted Saturday, January 10, 2009 12:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:07 PM
Points: 1,189, Visits: 1,051
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

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Yesterday @ 4:30 PM
Points: 21,860, Visits: 6,079
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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 31, 2009 3:35 AM
Points: 314, Visits: 399
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://www.linkedin.com/in/pareshprajapati
http://paresh-sqldba.blogspot.com/
Post #634485
EdVassie
Posted Monday, January 19, 2009 5:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 1,911, Visits: 1,502
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 configuration of SQL Server 2005 and 2008.
1 October 2009: now over 7,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Fun: You can lead a user to data, but you can't make them think (Anon).
Post #639201
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use