Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Upgrading databases from version 8.0 (2000) to 9.0 (2005)

Hi Experts,

We've successfully detached, copied and re-attached our CRM dtabases from a SQL 2000 instance to a SQL 2005 instance.  The are working fine but are version 8.0.  We're reinstalling CRM 3.0 now and the media we are using seems to want us to upgrade the database version to 9.0.  What is the safest and easiest way to get theese data bases that are already attached to the new SQL 2005 instance upgraded to 9.0

Thanks in advance
0
mevels
Asked:
mevels
  • 3
  • 2
1 Solution
 
momi_sabagCommented:
you can back them up and restore them
0
 
mevelsAuthor Commented:
We have detached the DBs and copied them over and are working - we need to UPGRADE the dbs themselves now
0
 
momi_sabagCommented:
if you restore a sql server 2000 database on a sql server 2005 instance, then it is upgraded during the restore operation
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mevelsAuthor Commented:
We could not restore the .bak files and had to resort to attaching the data files to the new instance - they are nicely attached and we really just want to upgrade them where they are
0
 
bcsqlCommented:
Easy, right click the DB select options. Change  the Database Compatibility mode from  to SQL 2000 (80) to SQL 2005 (90). Then you are done you do not have to restore anything.
Unless you need to run scripts from the vendor to up upgrade the DB to run with the app.
0
 
mevelsAuthor Commented:
Pretty obvious, but then again the right answers usually are!!!!  Thanks!
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now