Community
Showing results for 
Search instead for 
Do you mean 
Reply

Merging multiple act databases on Premium V16

New Member
Posts: 3
Country: USA

Merging multiple act databases on Premium V16

I have a question and the answer apparently can't be found using the Help funtion within Act. We ended up having 3 different Act databases that now need to be blended into one database that is then shared out by remote database. How can I blend/ merge these 3 databases?

 

I looked on here, but the references are to older versions by Sage that aren't shown on Sage's website anymore.

 

Suggestions??

 

Thanks,

 

Sean

Bronze Contributor
Posts: 1,276
Country: USA

Re: Merging multiple act databases on Premium V16

Blending databases can be either simple or complex depending on the structures.  If they are different, you need to ensure there are matching fields in the receiving database.  The users also have to be there as well.  Here's a good document/KB that talks about what you need to do.  Basically once ready you are going to be exporting from the two databases into one.  user management will be important to ensure you keep histories/activities/linked correctly.  And, depending on the size of the databases, be sure to allow LOTS of time for the merges to occur.  You have to do them one at a time.

 

http://kb.swiftpage.com/app/answers/detail/a_id/17539/kw/merge%20databases

 

Patricia Egen
Certified ACT! Consultant, Trainer, Developer
www.egenconsulting.com
(423) 875-2652

Follow us on:


Visit our Popular ACT Wizards Page Wizards Here!

Copper Elite Contributor
Posts: 232
Country: Germany

Re: Merging multiple act databases on Premium V16

Hi,

 

we do offer a service, where we merge your database, we did make a addon, where we can merge 2 database into one, without loosing any data. (even Private data is detected and merged.

 

we do it in the following way..

 

1. you must  purchase the database analyis, thensend us the backup´s of your database, then we will do a test migration, and give you access to the database to check the outcome.

2. when you confirm that the database is as expected, then you need to make the final payment, resend the data on i.e thursday, we will then run the merge, and you will then recive a backup of the merged database on sunday/monday (depending on the amount of data that is in the database) we can give you the final time estemate after you confirmed that the testmigration did work.

 

regards

 

Ingo Lange

 

 

 

ACC since 1995
Developer of Addons for ACT

CrmAddon Factory
+1 203 541 0040