June 22, 2011 at 11:35 pm
How to run the upgrade advisor during the migration time ie sql server 2000 to sql server 2008
June 23, 2011 at 6:40 am
Hi,
If you are working on upgrades to latest versions of SQL Server there are mainly two way to carry this task:
1) In-place upgrade
2) Side-by-side upgrade
Upgrade Advisor analyzes installed components from earlier versions of SQL Server, and then generates a report that identifies issues to fix either before or after you upgrade.
When you run Upgrade Advisor, the Upgrade Advisor Home page appears. From the Home page, you can run the following tools:
--Upgrade Advisor Analysis Wizard
--Upgrade Advisor Report Viewer
--Upgrade Advisor Help
The analysis examines objects that can be accessed, such as scripts, stored procedures, triggers, and trace files. Upgrade Advisor cannot analyze desktop applications or encrypted stored procedures.
Output is in the form of an XML report. View the XML report by using the Upgrade Advisor report viewer.
Regards,
Vamsi
Regards,
Vamsi Krishna S
MS SQL Server DBA
June 23, 2011 at 6:47 am
You don't run the Upgrade Advisor during the migration. You run it before the migration so you know what problems to fix before the migration.
Use the SQL 2008 Upgrade Advisor. And I advise doing a side-by-side migration from 2000 to 2008, in case you run into any major issues. Remember, if you do an in place upgrade, you won't be able to go back without a full restore of OS, SQL Server, and all databases.
June 23, 2011 at 7:12 am
thks for reply..one more small query
when i used sql upgrade advisor i couldn't find any error but when i compiled procedure that show show error..so i need how to run upgrade advisor steps
June 23, 2011 at 7:16 am
The advisor doesn't tell you about all errors. Syntax errors, for instance, I believe aren't registered by the advisor.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply