Notifications
Announcements
No record found.
I was looking at the latest version of the MS article that discusses how to move Dynamics GP to a new server. In the past the article would reference three scripts. A dex script, a grant script, and the change dbowner script.
in this latest version I do not see the dex script. I only see the grant and change dbowner script. Is the dex script no longer required? Please advise.
JG
For the Dynamics GP databases, moving them from one server to another, you'll want to use the steps and scripts mentioned in these articles:
KB 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
support.microsoft.com/.../how-to-transfer-an-existing-microsoft-dynamics-gp-microsoft-small-busi
**NOTE: The CaptureLogins script in step #1 of KB 878449 hasn’t been updated to work with newer releases of SQL Server, so, if you're using SQL 2017 or newer, you'll need to use this article to migrate the login information for GP users over to the new SQL Server:
KB 918992 - How to transfer logins and passwords between instances of SQL Server
support.microsoft.com/.../how-to-transfer-logins-and-passwords-between-instances-of-sql-server
The KB 878449 article describes how to transfer an existing Microsoft Dynamics GP installation to a new server that is running Microsoft SQL Server. The article also describes how to maintain the user logins and databases.
GP Power Tools Database Validation Feature fixes all the issues caused by moving SQL server. Recreating all the logins and database users.
Regards
David
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
