Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-12-17 : 08:32:01
|
| Dear All,I am new to administration,but having strong T-SQL knowledge.I didn't get a chance to migrate from 2000 to SQL 2005.But most of the time i was asked about the migration.If anybody help me in getting migration plan.concept wise and plan wise it will be great help.What are all the steps?How to plan for migration ?Pre and post check migrations ?Thanks in advance,GAngadhar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-18 : 09:21:36
|
| Before the migration, consider the following issues.1. What is the Edition of SQL Server 2000?2. What is the Edtiion of SQL Server 2005 you want to upgrade to?3. What is the processor architecture? If it is IA64, then you must upgrade to 64-bit. If it is x64, then SQL Server 2000 has only 32-bit builds. At the same time, SQL Server 2005 has 64-bit builds. You cannot upgrade 32-bit SQL Server 2000 to 64-bit SQL Server 2005 directly.4. What is the operating system running SQL Server 2000? If SQL Server 2005 editions requires a different operating system, is it acceptable to upgrad the operating system? For example, SQL Server 2005 Enterprise edition requires server operating systems such as Windows 2000 Advanced Server 2004, Windows Server 2003 Enterprise Edition SP1, and the coming Longhorn server. 5. Any special business and applicaiton logic?Please also download the latest BOL from MSDN website for detailed information. Once you decide to migrate, try side by side upgrade instead of in-site upgrade. SQL Server 2000 can be upgraded to SQL Server 2005 directly (if editions and processor architecture builds match). At the same time, SQL Server 2000 and SQL Server 2005 can be installed side by side successfully on the same machine if the resources allow. If resources allow, please follow the following recommendation.1. Install SQL Server 2005 side by side with SQL Server 2000, i.e., not direct upgrade.2. While SQL Server 2000 is still running, i.e., your application is still running, duplicate/copy data from SQL Server 2000 to SQL Server 2005. 3. Tune SQL Server 2005 and test SQL Server 2005.4. When you think SQL Server 2005 is tested well and works well, switch to SQL Server 2005. 5. You may uninstall SQL Server 2000. This is optional. Anyway, please back up your database before performing any major operations like this.RAQ Report: Web-based Excel-like Java reporting tool |
 |
|
|
|
|
|
|
|
Migration of SQL server from 2000 to 2005