Moving Existing Dynamics GP 8.0 to New Server

(0) Share

Report

Posted on by Community Member

Hello,

I am currently running a Windows Server 2003 box that has many problems and I have been tasked with moving it to new hardware running the same OS and version of Dynamics GP 8.0. I have a new box running Windows Server 2003 and SQL Server 2005 Express. Can I successfully move our instance of GP 8.0 over to the new box without losing anything? I managed to install GP 8.0 on the new box, but I'm not sure how to go about moving the old database over. Can anyone help?

*This post is locked for comments

I have the same question (0)

All responses (38)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Follow the steps in KB878449 and you should be fine.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Richard. I will give it a go. Wish me luck. :) Will this apply to FRx if I install that as well? I'll need to move any reports over too I believe.

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (1)

Report

You will need to install the same version of FRx on the new machine and make sure that all the companies ODBC connections are correct for the new server.

Once moved and operational, you can copy / move the FRx SYSData folder to the new machine.

Hope that helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Bill!!

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I would just export the spec sets out of the old FRx and import them on the new server. Depending on how old your FRx is and if it has been moved prior you may run into issues. Doing a fresh installation of Frx and importing the spec sets takes care of any potential issues.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

I like this idea as well - it does get to the same place - only difference is that Richards method does not rely on you getting all the pointers changed in the various configuration files.

Having seen this solution I would likely do the move - for the last part - in this manner - clean and simple.

Thanks Richard for the clarity of thought.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Bill, I have seen installations where over the years the server has been moved and FRx had this redirect path where you needed breadcrumbs to follow the yellow brick road back to the original location. Keeping it simple I just do the spec set export/import routine to avoid any hassles.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (0)

Report

Just a comment, but sadly not available for until Dynamics GP 2010.

Please look at GP Power Tools' Database Validation feature as it can simply recreate all the logins and database users once you have moved to the new server with new encrypted passwords (fixed or randomly generated) with password policy.

GP Power Tools Portal: http://WinthropDC.com/GPPT

David

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Does anyone have any tutorials on creating an ODBC connection on the server to connect GP to SQL? I'm having a hard time with it...

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

Start with opening File Explorer

Selecting WINDOWS folder

Find the SYSWOW64 folder

Then find the ODBCad32.exe file

Open this application and you have the ODBC window

Select System DNS

Click on Add

From the list, find SQL Sever Native Client ( 10 or 11 )

Enter a name and descriptions

IN the Server box, click the drop down and find the name of the SQL Server and named instance you want to connect to

Click Next

I use the "With SQL Sever" option

Enter a USER ID and Password that has SQL Server access - it can be SA

Click NEXT and remove the check marks from the boxes on the two following screens

Click Finish

On this final page you can test your connection. If you have a problem it gives a pretty good explanation of what you need to fix.

****

Put this together on the fly - but I hope it helps.

If it does not work - please post with more specific request and we can get you a more complete answer.

Was this reply helpful? Yes No