Solved

How do I access MSSQL UPGRADE Advisor?

Posted on 2006-11-30
2
248 Views
Last Modified: 2006-11-30
I have a MSSQL2000 DB and need to move it to a MSSQL2005 platform. Can you help me understand the steps to perform this "upgrade" of the DB?
0
Comment
Question by:johndarby
2 Comments
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 total points
Comment Utility
Hi johndarby,

As a first step - here's a link for the Upgrade advisor which will give you some info on potential issues in the move to 2005:

http://www.databasejournal.com/features/mssql/article.php/3595276

Cheers,
Hillwaaa
0
 
LVL 1

Author Comment

by:johndarby
Comment Utility
Thanks. That hit the spot!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need Counts 11 40
Microsoft SQL Queries 11 47
sql query 7 34
c# code 19 57
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now