Multiple Databases

[Darren24]

I am trying to merge two databases that we use, without losing any of the history data etc.... Just to give you some background, we have two databases (made up primarily of the same companies) However there would be different contact names for these companies (different purchasers of products).

However, not all the calendar and history data is being shared between databases and there is differences in the number of companies being set up. As a result, I would like to merge the two databses together, having the main contact in one becoming an additional contact in the main databsew without losing all the history and calendar data that we had vbefore. Is this possible? How would I go about doing it? Your help would be greatly appreciated!

 

[ddeegan]

Hello

I had a similar project with Goldmine 4. I used Visual dBase 5.6 to create a bunch of scripts. If you are using 5, you could use Transact SQL. However, you will need to be very familiar with the Goldmine table structures.

I'm not sure if you are familiar with programming. To import records to contsupp, & conthist, you may have to generate recids. There is a product called Goldbox that may be helpful to you. It sounds like you will need to map the whole process out, clean up data, etc. Then you may have to consider a consultant. If you do need to use a consultant, make sure you have all of your details worked out before you bring them in.

Another option is to transfer all of the records from one set into the other, then look into the merge/purge feature.

Good Luck
Dave

 

[richardy]

Dave,

Just for information, theres also a product called Inaport

http://www.inaplex.com

its actually more powerful and faster than GoldBox, although GoldBox has some extra features.

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com