Issues restoring act 8 database to act 18

[philtron]

Need tips to assist in restoring act 8 database to new install of act 18. Error as attached. Followed all steps to create backup. 

act error.jpg ‏321 KB

[Gary W · Accepted solution]

Hi Philtron,

Upgrading from Act! versions 7 & 8 (2005 & 2006 respectively) to a recent version of Act will cause this error. This is due to the versions of Microsoft SQL that are in use.

Act v7 & 8 used SQL 2000. When Microsoft developed SQL 2014, which is used in new installations of v18, they did not include a direct upgrade path for databases from SQL 2000 to SQL 2014. To get around this issue, it is necessary to upgrade the database using a version of SQL that has an upgrade path to SQL 2014. This can be either SQL 2005, 2008, or 2012.

To do this for your database backup, you'll need to follow the steps below:

1. Uninstall Act
2. Uninstall SQL 2014
3. Install a version of Act that uses SQL 2005, 2008 R2 (I'll send you a PM with a download link to a suitable version of Act)
4. Restore and upgrade the backup
5. Take a new backup of the same database
6. Uninstall Act
7. Uninstall SQL 2008 R2 (or 2005)
8. Install Act v18
9. Restore and upgrade the backup

I apologise for this inconvenience, but this is a limitation of Microsoft SQL.

[jonmklub]

Did you do a restore or restore as?

make sure restore as.

[Cecil_Taylor]

If you are upgrading from Act 8 to Act 18  please have a look at this KB article

http://kb.act.com/app/answers/detail/a_id/38225/~/how-to-upgrade-to-act!-v18-from-a-previous-version

[philtron]

Thanks for your reply. I did restore as. Attached is the error produced. To be clear, the ACT 8/2006 database was on an XP machine, and ACT 18 is on a Windows 10 PC. In the old ACT, I went to backup, and created a new backup file, and then on Windows 10 I attempted restore as and selected the zip file created from the backup.

error.jpg ‏308 KB

[Gary W · Accepted solution]

Hi Philtron,

Upgrading from Act! versions 7 & 8 (2005 & 2006 respectively) to a recent version of Act will cause this error. This is due to the versions of Microsoft SQL that are in use.

Act v7 & 8 used SQL 2000. When Microsoft developed SQL 2014, which is used in new installations of v18, they did not include a direct upgrade path for databases from SQL 2000 to SQL 2014. To get around this issue, it is necessary to upgrade the database using a version of SQL that has an upgrade path to SQL 2014. This can be either SQL 2005, 2008, or 2012.

To do this for your database backup, you'll need to follow the steps below:

1. Uninstall Act
2. Uninstall SQL 2014
3. Install a version of Act that uses SQL 2005, 2008 R2 (I'll send you a PM with a download link to a suitable version of Act)
4. Restore and upgrade the backup
5. Take a new backup of the same database
6. Uninstall Act
7. Uninstall SQL 2008 R2 (or 2005)
8. Install Act v18
9. Restore and upgrade the backup

I apologise for this inconvenience, but this is a limitation of Microsoft SQL.

[philtron]

Thanks, I will attempt that and update the post.

[philtron]

This worked perfectly. Definitely takes a while.