Solved

How do I access MSSQL UPGRADE Advisor?

Posted on 2006-11-30
2
281 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
ID: 18049259
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
ID: 18049337
Thanks. That hit the spot!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database ERD 4 31
backup and restore 21 30
Stored Proc - Rewrite 42 60
Casting is giving error in sql server 3 12
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

830 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