web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Move GP SQL to new Ser...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Move GP SQL to new Server Scripts

(0) Share

Report

Report

Posted on by SL_GP_BC_123

1,108

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Derek Albaugh Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

GP Power Tools Database Validation Feature fixes all the issues caused by moving SQL server. Recreating all the logins and database users.

Regards

David

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 616

#2

André Arnaud de Cal... 460 Super User 2026 Season 1

#3

Syed Haris Shah 331 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans