Community
Showing results for 
Search instead for 
Do you mean 
Reply

converting database

New Member
Posts: 6
Country: Israel

converting database

i just bought a new computer on windows 8.1 

i bought and installed act pro v17

my old version on my old computer was act 2008 v10

i want to get my database from my old computer to my new act in my new computer 

how do i do it?

thanks

Josh 

Bronze Contributor
Posts: 1,393
Country: USA

Re: converting database

One of the gurus will have to confirm, but assuming that you can upgrade from 2008 to 2015, go to the older computer and create a backup using the built in backup program.  Make sure you check the include attachments.

 

You then take that Zip file to the new computer and run a "Restore As" and give the database a new name. 

 

Hey any guru reading this, can the user upgrade straight from 2008 to V17?

John Purdy
ACT! Premium 2016 (V. 18)
Main: HP 9470M 8GB, Win 10 Pro, & Exchange 2013 & Office 365, 32bit
Remote: Dell XPS Ultrabook with 4GB & Win 10 Pro, Office 365 32bit & Exchange 2013
New Member
Posts: 6
Country: Israel

Re: converting database

thanks - i will try it and let you know what happens,

josh 

New Member
Posts: 6
Country: Israel

Re: converting database

no link here - try again pease
thanks
josh
Bronze Super Contributor
Posts: 1,543
Country: United_Kingdom

Re: converting database

As an Act! Certified Consultant (guru!?) I agree that what John Purdy is suggesting is correct.

 

Let us know by replying to this thread.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
New Member
Posts: 6
Country: Israel

Re: converting database

did the zip 

brought it to my new computer  - 

how do i do a restore as  ?

tx 

jb

New Member
Posts: 6
Country: Israel

Re: converting database

ok - figured out how to do the restore as - 

immediately got error message ; cannot backup device c:/ - - -   operating system error 5(access is denied)  RESTORE DATABASE terminating abnormally 

--- cannot open backup device

New Member
Posts: 6
Country: Israel

Re: converting database

never mind - i figured it out KB 23593!!

YAY!

JB

TN
Tuned Listener
Posts: 58
Country: USA

Re: converting database

Hello,

 

I think even I am in same situation, I was using ACT 2006 ver8 and I have taken backup of Database and now I want to restore this backup into ACT v17 but it is giving error

 

"Database was backed up on server running version 8.00 . that version is incompatible with this server, which is running version 12.00.2000 "

 

 

Please let me know what is the solution for this.

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: converting database

I believe the issue is the SQL server. ACT! 2006 use a very early version of the MSSQL server and I don't believe that the SQL 3014 (used by ACT! 17.1) will restore databases from that early version of the ACT! program.. I believe that the database could be restored to a system using SQL 2008 R2 and then a backup from that system could be restored to the latest version of the ACT! program.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129