01-26-2011 10:22 AM
One of our clients ACT database melted down and they did NOT have ANY backup.......
We were able to the data so we can view it it MSSQL server and run the select statements, so the data is there but it does not work with ACT anymore. We can see all the tables/field values, but the issue here is now how do we get the data out of that MSSQL database? Where do I find/get relations between the activities? Is there a couple queries that I could run and it would return a list of activities so I don't have to go over all the database and figure that myself out?
Note, we are moving out of ACT so need to get the data out of ACT to .csv~ so we can import it to other CRM.
Any help appreaciated.
01-27-2011 06:10 AM
You mention that you have the 'MDF' file - generally the only database file used by Act! with an MDF extension is the Email database. The main database would have an 'ADF' file which contains the fields and data.
If you have the ADF and LDF files for the database, you can attempt to open it through Act! using the ADF instead of a PAD file.
If the database file is attached to SQL, you can try using an OLE/DB2 connection to pull data out: Here is an article with some samples instructions for creating a query: KB Article 25837
01-27-2011 12:03 PM - edited 01-27-2011 12:05 PM
Thanks! that was what I was looking for.
Couple questions what is stored in the following tables:
TBL.History_Partial -whats that
TBL.History_suspect - ?
Thanks for your help!
01-27-2011 02:07 PM
01-28-2011 12:40 PM
The last qualifier of the tables listed are actually status indicators. For example: TBL.Activity is the table and Suspect is the status.
01-28-2011 01:08 PM
I cannot help with the situation, but wanted to say thanks for posting. It made me realize we were not backing up our database regularly. Now I have scheduled regular backups. So hopefully we will be better prepared for any problems.