Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Migration

New Member
Posts: 2
Country: United States

Database Migration

I have been using ACT 2000 for the past 4 years to track customer/prospect interactions at a small company.  I never upgraded because, "if it ain't broke, don't fix it."  We have been using XP but are now considering a migration to W7.  Is there an easy migration path for a 2000 database that holds about 1,800 contact records?
Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Database Migration

Make sure that you have a good backup of the 2000 database.

 

See if you can dig up a trial copy of 2010 - I did not think that Sage was offering, but another thread here referenced that they had a trial copy.

 

Install the 2010 trial on the desired machine - you should be able to have both 2000 and 2010 on the same PC.

 

From w/in 2010, choose 'Open Database', change database type to 'Act! 3-6 database' and browse to a copy of the 2000 database.  Act! should do its thing and make a 2010 version of the database.

 

Test 2010 out and make sure you are happy with the results, keeping in mind, that any changes made to the test database will be lost if your are going to repeat the process again later for a live rollout.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Database Migration

You do need ACT! 2010 for Win7... but first, backup and clean the database

 

I usually find a better conversion if I first get the ACT! 6.0 30-day trial from this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1319...

 

The run ACTDIAG maintenance as per this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1198...

 

The ACT! 6.0 version of ACTDIAG could fix more issues.

 

Then go to Win7, install ACT! 2010 and convert the data as per this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2517...