Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
RobinBonin 5/22/2012 9:25:59 PM

Merging Companies on two SQL servers to one

Hi, I have a GP 2010 with 2 companies on it, and 2 additional companies on another SQL server.

I was planning on creating an empty company on the target server to create the entries in the Dynamics database, then overwrite the company file with the data from the second SQL server.

Everything appeared to look like it was working at first, but when I perform certain actions, like looking at some distributions, I get SQL errors. Is there anyway to rebuild the missing dynamics data from the company file?

Version: GP 2010
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables