Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - SQL Server 2000 to 2005 Upgrade for GP 9.
  FAQ FAQ  Forum Search   Register Register  Login Login


SQL Server 2000 to 2005 Upgrade for GP 9.

 Post Reply Post Reply
Author
Message
Allan View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: October 30 2005
Location: United States
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote Allan Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server 2000 to 2005 Upgrade for GP 9.
    Posted: September 12 2006 at 11:19am
Very soon I am going to Upgrade SQL Server 2000 (which has my GP 9.0 database) to SQL Server 2005 ? Are there any known issues?
Back to Top
Sponsored Links


Back to Top
victor View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 07 2005
Location: United States
Status: Offline
Points: 112
Post Options Post Options   Thanks (0) Thanks(0)   Quote victor Quote  Post ReplyReply Direct Link To This Post Posted: September 18 2006 at 8:07am

Make sure you understand two options: (1) in-place upgrade, (2) side-by-side migratrion. In in-place upgrade the existing SQL Server will be un-installed and new SQL Server will be installed and everything will be updated automatically. In the side-by-side migration you will be creating a new instance of SQL Server. So your server will have both SQL Server 2000 and SQL Server 2005 running at the same time. Then you can detach or backup the db from 2000 to 2005 instance. In side-by-side migration you'll have to manually create the login etc. (by making script from 2000 server). Aslo before even running the upgrade/migration, run the SQL Server 2005 Upgrade Advisor program. You'll find the Upgrade Advisor from 2005 CD or you can also download from Microsoft website.

Back to Top
rjavins View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: November 16 2006
Location: United States
Status: Offline
Points: 48
Post Options Post Options   Thanks (0) Thanks(0)   Quote rjavins Quote  Post ReplyReply Direct Link To This Post Posted: November 16 2006 at 7:40pm
There is also a techknowledge (878449) available that assists you in this process.  Additionally, the techknowledge has a script that needs be ran against each company database because SQL 2005 handles schemas differently than SQL 2000.
Back to Top
Joseph A Nader View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: September 14 2006
Location: Lebanon
Status: Offline
Points: 360
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joseph A Nader Quote  Post ReplyReply Direct Link To This Post Posted: November 17 2006 at 1:42am

For those who have upgraded from SQL 2000 to SQL 2005, what exactly are the advantages...and what is added in 2005, which we could really benefit from....Just a quick overview...

Thx

Joseph Abou Nader, PMP



MCT
,MCTS,MCBMSS,MCSA
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com