Best way to move Dynamics GP (Data and Server)

(0) Share

Report

Posted on by Community Member

Our company is planning to move our core IT infrastructure from our headquarters to one of the other locations (another province). What is the best way to have a seamless move of data and server for Dynamics GP? Is it replication?

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Community Member on at

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Yup, that's one way I'm looking at but given the amount of data (approx. 35GB) and the bandwidth at the new location (3Mbps), it will definitely cause some downtime.

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

How big is the data? If you have the networks connected, then you should be able to send the data down the line.

Do a backup and compress - then send to the server in the new location.

Using Remote Desktop you can then do all the work on the remote site as if you are there.

Now, if the new site is sunny and warm - get on the plane - but if cold and rainy - RDP is the way to go.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Based from what I'm reading here, I guess my only option is to backup the data, hop in the plane and fly-out to the new office, perform the move/restore procedure for Dynamics to the new server then reconfigure Dynamcis GP clients. I wanted to avoid this kind of process to minimize downtime but it looks like downtime is inevetable. Thanks everyone for all your inputs.

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Hi Sandip

This is the Database Validation feature of the product GP Power Tools.

You need to install and register the product. Well worth it.

David

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Hi David,

After long time we are talking. I hope all is well at your end. Can you please share "GPPT" script or more details.

Thanks Much

Sandip

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Sandip, fixing the logins and passwords with GPPT is much easier than the scripts and manual steps in the article. The rest of the article is great.

David

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Ariel,

Follow KB - https://support.microsoft.com/en-us/help/878449/how-to-transfer-an-existing-microsoft-dynamics-gp,-microsoft-small-business-financials,-or-microsoft-small-business-manager-installation-to-a-new-server-that-is-running-microsoft-sql-server

I have used several time and successfully moved Database to new server with user logins. Yes you need to reset password but login Id it keep same.

Let me know how it goes.

Thanks much
Sandip

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

Both Richard and David provide get solutions and suggestions. It is our experience that the planning and execution of the planned move are of critical importance. As Richard noted, if you can set up the new site in advance and do some test moves that is by far the best way to go.

Once you have committed to a date for the move, then stick with it, plan up to it, test prior.

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

I complete concur with David. GPPT is the way to go for this task and many others!

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

Like (0)

Report

RE: Best way to move Dynamics GP (Data and Server)

When you come to recreating SQL Logins and Database users and ensuring the correct dbo and permissions, these are all tasks that GP Power Tools' Database Validation was created to do. It can fix these issues plus many more quickly and easily.

David

Was this reply helpful? Yes No