December 14, 2010 at 6:37 am
I have an existing SQl 2000 server on Windows 2003. My application team wants to install SQL 2005 on the same machine by uninstalling SQL 2000 and Installing SQL 2005. They dont want to go by inplace upgrade because of the new naming structure used for the folders.
My SQL 2000 is having 150 DTS packages....is there a way i could back them up and restore in SQL 2005
Regards
Nimesh
December 14, 2010 at 7:16 am
Save them to the file system, then import them into the new SQL instance.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 14, 2010 at 7:19 am
Do i need to manully save all the 150 packages.....is there any autmated way for this ?
Regards
Nimesh
December 14, 2010 at 9:43 am
Use Darren Green's DTSBackup 2000 to save all the packages. It's free and works well. Get it here: http://www.sqldts.com/242.aspx
Greg
December 14, 2010 at 10:19 am
The DTS packages are stored in the msdb.dbo.sysdtspackages table on a SQL Server 2000 instance. So a simple backup and restore should get all your DTS Packages. Or you can even tranfer the data from the table to another SQL Server instance and then re-export. Copying the packages as file system packages is also a very good approach. Test it well before you do it.
Check this Link
Thank You,
Best Regards,
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply