Print Page | Close Window

SQL Server 2008

Printed From: Microsoft Dynamics Forums
Category: Microsoft Dynamics SL (Solomon)
Forum Name: SL - Installation and Administration
Forum Discription: Installation, Upgrade, Service Pack, Security, Database, Administration, SQL Server, Login Issues, System Errors, Performance, EDI, Business Portal, and related topics
Printed Date: July 03 2020 at 7:44pm

Topic: SQL Server 2008
Posted By: lansishao
Subject: SQL Server 2008
Date Posted: May 05 2011 at 1:05am
Currently we are using SQL Server 2000, we will going move the database to SQL Server 2008. May i know what is the best way to do it? (restore, attach or what)

Beside that, may i know what is Backward Compatibility?

Posted By: kfinn
Date Posted: May 05 2011 at 4:54am
As part of the upgrade (in database Maintenance) there is an option in the update scenarios to upgrade the database.

Kevin Finn
Senior Partner
N2 End IT Solutions
London, UK

Posted By: lansishao
Date Posted: May 05 2011 at 7:35pm
is it your mean is use the solomon database maintenance(98.290.00)?
besides that, what is the best way to move sql 2000 database to sql server 2008?

Posted By: cicel
Date Posted: January 25 2012 at 9:20am
Hello, i always backup first in my bd server 2000 , and later restore my bd in the 2008 server
anyway, if you detach, need to have a backup alwasy,.. sometimes the attached makes some errors.
have fun

Print Page | Close Window