web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Direct Table to Table ...
Finance | Project Operations, Human Resources, ...
Unanswered

Direct Table to Table Copy

(0) ShareShare
ReportReport
Posted on by Community Member

Hi:

An end user cannot use the conventional means of upgrading to the latest version of GP and must conduct a direct "table to table" copy of data from the production SQL to the test SQL server instead of using GP Utilities.

In other words, we're going to need to copy "transaction tables" of each module from the old to the new servers.

This is because their databases have corrupt data brought on by obsolete code of programmers that are no longer with that company.

Are there any issues with conducting this sort of copying of data?  Will SQL Linked Servers need to be set up?

Thanks!

John

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You are talking about a tremendous amount of work here. How will they determine what is good and what is not?  May I suggest creating a test company and cleaning up that database and then upgrading the test company? There are hundreds if not thousands of table linkages and indexes and triggers. Sure it can be done but they better have deep pockets and enlist the help of a consultant with  extensive knowledge of GP databases.

  • Justin Sutton Profile Picture
    Justin Sutton Microsoft Employee on at

    Hello John,

    We strongly recommend against doing any manual upgrades without the assistance of GP Utilities.  

    There are a lot of checks and validations that occur during the upgrade process that you will be skipping, and there is a massive chance that something, somewhere, will get missed.

    Richard's recommendation is the way to go. Clean up a test company, and see if that upgrades successfully.

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.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
Subra Profile Picture

Subra 386

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 270 Most Valuable Professional

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