Prepare for SQL Server 2005 migration
1. backup SQL Server 2000 db and restore to localpc
2. fixed userid in the restore db
3. find Microsoft SQL Server 2005 Upgrade Advisor
http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en
Upgrade Advisor
1. Start UPGRADE ADVISOR ANALYSIS WIZARD
We have two options:
a.Launch upgrade advisor analysis wizard
b.Launch upgrade advisor report viewer
We will select option a.
2. Select SQL server and which component wants to analysis :
SQL Server
Analysis Services
Notification Services
Reporting Services
Data Transformation Services
4. Select which authentication mode. Windows Authentication or SQL Authentication mode
5. Select which database want to analysis
We can save the analysis file to analyze trace file or to SQL batch file
6. Last Step, Upgrade Advisor will show summary of the server, component and database, which want to analysis
If previous upgrade advisor report exists, Upgrade advisor will be given warning "Previous upgrade advisor report exists and will be overwritten"
We can select whether want send reports to Microsoft
7. Upgrade advisor will start analysis the component
8. Wait for while depand how big is your database, Upgrade advisor will end with a analysis report
9. We able to filter report by server, Instance or component, Filter by issue (Pre-upgrade issue, migration issue, solve issue)
>More about SQL Server 2005 Upgrade advisor
You can find SQL Server 2005 Upgrade Handbook here
You also can get 350 page document contain how to move SQL SERVER 7 OR SQL SERVER 2000 to SQL SERVER 2005 here
