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