News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Direct Table to Table ...

Microsoft Dynamics GP forum

Unanswered

Direct Table to Table Copy

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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:

Administration and Setup

All responses Img

All responses (2)

Answers Img

Answers (0)

Justin Sutton on at

Like (1)

Report

RE: Direct Table to Table Copy

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.
Richard Wheeler 75,730 on at

Like (2)

Report

RE: Direct Table to Table Copy

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,645 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans