DataBase - Upgrade DB version from SQL Server 2000 to SQL Server 2005

Asked By arielq

02-Feb-09 12:12 PM

Hi, I have a deployment with GP 9.0 SP3 with SQL Server 2000. I want to
upgrade de Database engine to SQL Server 2005 in order to use SQL Server
Analysis Services, SQL Server Integration Services and SQL Server Reporting
Services.

What can I do to accomplish this DB Upgrade? Do anyone have the formal set
of steps to execute?

Please help me!!!!!!

02-Feb-09 02:00 PM

I am sure others will have more suggestions for you, but here is what I
recommend for a smooth upgrade to SQL Server 2005 from SQL Server 2000.

1) Make sure you have all your database backups in place

2) Install the SQL Server 2005 Upgrade Advisor. I use it to make sure I have
all prerequisites in place before attempting the upgrade (service packs, .NET
framework, memory, space, etc.). You can obtain a copy of SQL Server 2005
Upgrade Advisor at
http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en

3) Have a test environment that is as close as possible to your production
environment. This will ensure you are testing with the latest data and
perhaps, the latest configuration options.

4) Run your test upgrade and evaluate results

5) Run your production upgrade

You can also find more upgrade information in the "SQL Server 2005 Upgrade
Handbook" article available at
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

02-Feb-09 02:29 PM

Mariano, thanks for your help, but I know those steps are related with SQL
Server. But, related with GP, is there any special consideration?

I mean, let's suppose the SQL Upgrade process works fine. In that case, GP
users will work without problems? Should some utilities or stored procedures
must be executed?

Is there any documentation related with this task.

02-Feb-09 02:30 PM

Mariano, thanks for your help, but I know those steps are related with SQL
Server. But, related with GP, is there any special consideration?

I mean, let's suppose the SQL Upgrade process works fine. In that case, GP
users will work without problems? Should some utilities or stored procedures
must be executed?

Is there any documentation related with this task?

02-Feb-09 02:48 PM

There are no specific requirements for GP as long as you only upgrading the
database server.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

03-Feb-09 11:33 PM

Dear, nothing required for GP, just up-grade sql 2000 to sql2005 but i
suggest u no need to up-grade sql2000, just install new instance of
sql2005 on same machine and after this download capturelogin.sql
script from microsoft site and run against master database in server
sql2000 but before running this script please open and read
instruction which already defined my MS and after running this script,
run this script output against master database in sql2005 and after
this open ur gp make a new connection with ur newly created instance
name for sql2005, login as "sa", then goto tools>system>users and open
one by one user and press save button.

BR,
SMA

L
P
res
have
, .NET
05
..
ion
ade
to
ver
orting
l set