Lot of people ask how we going to migrate SQL Server 6.5, SQL Server 7, SQL Server 2000 to SQL Server 2005
If you still using SQL Server 6.5, you can't direct upgrade to SQL Server 2005. You will need to perform 2 step job. First update SQL Server either to SQL 7 or SQL 2000 and then upgrade to SQL 2005
If you using SQL Server 7.0 or SQL server 2000, you have have few method for migration
1. Side by side migration using Copy database wizard
2. Backup and Restore
3. Attached and detach
4. direct upgrade from SQL 2000 to SQL 2005 (Only applicable for SQL 2000)
Showing posts with label SQL 2005 migration. Show all posts
Showing posts with label SQL 2005 migration. Show all posts
Thursday, September 28, 2006
Tuesday, June 13, 2006
SQL Server 2005 - Prepare for Migration
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
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
Subscribe to:
Posts (Atom)