03-25-2013 01:53 PM
I'm having a devil of a time updating from 2005 to 2013. New version is on a new computer so this is an upgrade and a migration.
I first used backup to create zips on the old computer but could not get those to load on the new version.
I then followed the instructions to unhook the database from SQL, copied the database files to the ACT folder on the new computer. I then opened the new folder and it said it needs to update the database. OK. Now I've got the box with the little circles that says "Working...", but it's been working for a couple of hours.
It's not crashed but doesn't appear to be doing anything. According to resource manager, Act isn't using any CPU or HD. How long could this possibly take? My database is under 1500 customers.
03-26-2013 07:24 AM
03-26-2013 09:17 AM
Well it was still "working" this morning when I came in.
Dell Optiplex with fresh install of Windows 7 Pro.
When I attempt to restore the backup file it says working, then says failed deleting temporary files and I get a big error window with lots of text but I can't cut and paste the text from it and don't see a way to attached a picture here so can't send a screen grab.
Errors when creating a new database, similar window as above.
I de and re-installed ACT and got same errors. I restored the computer from a drive image taken before the installation of ACT, re-installed ACT and now having same problem.
I now took my old database files and pasted them into the Act folder and tried to open. Failed. Tried to open existing database and it was listed but if I try to open I get :
Exceptions occurred while executing the database Schema Update Script.
Contact your Administrator for assistance.
Changed database context to 'master'.Changed database context to 'Accounts'.
*********** Schema Update failed **************
*********** Exception message follows *********
I've killed a weekend and now a 2nd work day on this.... frustrated.
03-26-2013 10:01 AM
03-27-2013 01:59 AM
no problem with act 2013,
first I need the exact built no of your 2005 program
there are some issue you can't directly update the db from 2005 to 2013
second please go to ACTDIAG
you can also try doing db repair.
03-27-2013 09:54 AM
I am upgrading two computers. Both are identical Optiplex and both fail. One is upgrading from Act 2005, the other from 2010.
I tried running Actdiag on the old machines on the database before backing up.
Just tried Actdiag on new machines for first time and it fails.
I tried Tools>Restore database>Restore database from backup as in Actdiag on the new machine and I get "Unhandled exception has occured... Tried running as administrator with no change. Only one user machine and user has administrative privelidges.
I don't know if I'm having a SQL problem or or a permissions problem but I'm on my 5th day of working on this and my 3rd work day wasted, I"m completely frustrated and I don't know what to do about it.
03-27-2013 10:28 AM
Since you are getting the errors when restoring a database and when attempting to create a new database, it appears there is either an environmental issue, or SQL is not installed correctly.
To see if there is a conflicting program, try restarting the computer in 'Selective Startup', then attempt to restore/create a database. Here is an article with instructions for Selective Startup: KB Article 21966