Community
Showing results for 
Search instead for 
Do you mean 
Reply

Issues restoring act 8 database to act 18

Accepted Solution Solved
New Member
Posts: 4
Country: USA
Accepted Solution

Issues restoring act 8 database to act 18

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


Accepted Solutions
Solution
Accepted by topic author philtron
‎12-28-2016 01:46 PM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Issues restoring act 8 database to act 18

[ Edited ]

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.

View solution in original post


All Replies
Silver Contributor
Posts: 1,813
Country: USA

Re: Issues restoring act 8 database to act 18

Did you do a restore or restore as?

 

make sure restore as.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Copper Contributor
Posts: 13
Country: United_Kingdom

Re: Issues restoring act 8 database to act 18

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

New Member
Posts: 4
Country: USA

Re: Issues restoring act 8 database to act 18

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.

Solution
Accepted by topic author philtron
‎12-28-2016 01:46 PM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Issues restoring act 8 database to act 18

[ Edited ]

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.

New Member
Posts: 4
Country: USA

Re: Issues restoring act 8 database to act 18

Thanks, I will attempt that and update the post.

New Member
Posts: 4
Country: USA

Re: Issues restoring act 8 database to act 18

This worked perfectly. Definitely takes a while.