Upgrade SQL 2000 To SQL 2008 x64 IA | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Upgrade SQL 2000 To SQL 2008 x64 IAHello All,I am going to upgrade our production from SQL server 2000 to SQL server 2008 x64 IA by using side-by-side method I have 2 Issue need your support which are:Q1, I have a lot of DTS must migrate them to SSIS around 500 DTS and I need a sold way and smooth , do i need to reschedule my DTS again after migrate them To SSIS??Q2, I was looking for a way to sync databases between the 2 DBs Servers (2000, 2008) Any idea/clue is welcome. Thanks in Advance
1. in BIDS there is an option to import DTS packages. another time consuming option is to save each DTS on the new server. you’ll have to open and save as each one. then try to transfer the job to the new server to see if it works. been a while since i did this and not sure if it works or how easy it is. in a few cases we made new SSIS packages that execute a DTS and a new job around them.
2. how large are the databases, are they on a SAN and how fast is the network? we’ve done server upgrades and disconnected the old servers from the SAN, connected new ones, installed SQL and attached the db’s. we’ve also done the backup and restore method as well as network copy. in SQL 2005 there is a copy database job in BIDS but if you have large databases it will take a lot of time.
I would suggest you to go throuogh few links before you really start working on this, http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/
http://msdn.microsoft.com/en-us/library/ms143462.aspx, and http://searchsqlserver.techtarget.com/tip/Migrating-SQL-Server-2000-DTS-packages-to-SSIS
For your Q2, what exactly you wants to achieve? You may use any options such as Replication or DB Mirroring!