Most users of ACT! legacy versions such as ACT! 2.0 to 6.0 think that they can just buy the new SQL based version of ACT! and easily upgrade their databases. Users think that they can simply upgrade their old databases by just installing the ACT! 2009 software on their computers or company servers and allow the program do the rest.
Not so fast folks! I can’t begin to tell you how many phone calls I receive from users that buy the new version of ACT! and tell me that their conversion attempts have failed. No surprise there!
The reasons database conversions of legacy versions of ACT! fail are because the structure of old ACT! is very different from the new SQL based version of ACT!. Sage Software launched its SQL based version of ACT! in 2005. Since 2005, Sage Software has made major strides in the structure of ACT!’s back end database as well as the its features.
The new version of ACT! is now more complicated than its predecessors. ACT! is made up of many SQL tables that run the program making the back end of the database elaborately interconnected.
ACT! now requires that its legacy versions are cleaned up before they are converted. The clean up process is not easy and users should look to hire an ACT! Certified Consultant to help with conversion.
Some of the common mistakes found in legacy versions of ACT! are the following:
1. Renamed core fields
2. Broken links to attachments
3. Entry or exit triggers in fields
4. Fields with bad characters
5. Additional address fields
6. Private contacts
7. Activity errors
8. Unknown users
If an old database has any of the aforementioned issues then the cleaning process of the legacy version tends to be tedious and could require hours of work.
In addition, in order to seamlessly convert a legacy version of ACT! it must also be scanned and repaired using the ACT! diagnostic tool. The scan and repair tool found in the diagnostic tool of ACT! will scan the database’s structure. It will also repair any other structural issues it finds wrong with the database.
A knowledgeable ACT! Certified Consultant will take the appropriate steps to ensure that all of the issues mentioned above are remedied before attempting the conversion of a legacy version of ACT! to the most recent version of the software.
The bottomline is: Convert your legacy ACT! databases by hiring the services of an ACT! Certified Consultant.
