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 IA

Hello 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!


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |