02-11-2013 03:53 PM
Sorry if this has been asked/answered but I need some help merging ACT databases.
Current we have two sales guys. One is leaving and the one staying needs to have his ACT database updated so that he has all the data that the guy leaving has. I have seen several KB articles that show how to do an import of the database. I have tried this method but when import process gets to the notes part the import slows to a crawl. I watched it run for about 4 hours. It then threw an 'System.OutOfMemoryException' and the import process stopped and hung. I have run a 'Check & Repair' on both databases and both checks returned no errors. Each time I try to run the import the notes import slows down and at some point I get the exception.
Both machines are currently running Act 2012 Pro. The guy leaving has a Windows 7 laptop. The guy staying has Windows XP.
Would someone mind illuminating this for me? Is this the right process to use or should I try something different?
02-13-2013 08:12 AM
Welcome to the Sage ACT! Online Community!
The description points to a large number of notes in the database ('large number' can be relative to system resources).
- Make sure you are attempting to import the 'smaller' database into the larger database. If need be, you can backup the 'complete' database and restore on other computer.
- Do you have both databases on the same computer? If not, perform backup of the 'smaller' database and restore it on the other computer > then attempt the import.
- Try the import process on a different computer (backup/restore database as necessary to get them on same computer).
02-13-2013 10:35 AM
Thanks for the response. I have tried the following:
Importing the ACT database on a different computer - Tried this. Import crashes at practically the same spot.
The database both have the nearly the same amount of contact records - 13158 vs 13197
Basically, the guy leaving has created notes for each account that the guy staying needs.
Is there a better method than the one I am trying? Perhaps a third-party utility?
02-13-2013 10:52 AM