Load ACT backup files into SQL-Server

I have a client whose ACT contacts table was scrambled due to a rogue PDA synchronization.  I have backup files produced by AutoAdmin III from prior to, and after, the corruption.  I need to find a way to load them into SQL-Server to identify the affected rows.  The files are named like SQL-Server files (xxx_master, xxx_model, dbname) with a .bak extension.  SQL-Server states they are "not in a primary database format" if you try to attach them.

Thanks in advance.
LVL 13
AielloJAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
You should be able to use File | Restore in ACT!

For PDA, I find issues with a lot of the link solutions. The best option (if using Blackberry or Windows Mobile) is Handheld Contact. You can download a trial to test from www.GLComputing.com.au/HHC
0
AielloJAuthor Commented:
Would we be able to restore only the Contacts table?

FYI:  The corruption was caused by users not properly signing out from the Remote Access Server (RAS).  "Orphaned" RAS sessions running when the user synchronized her PDA caused the Contacts table data to be scrambled.  My company (a vendor to the client) is now categorized as an accounting tax client with some other name listed as the owner.
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
No, you can't just restore one table.

What PDA do they use?
What do they use to sync it to ACT!?

Do you have a backup before the damage? If so, you might look at restoring that.
0
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

AielloJAuthor Commented:
Unfortunately we have to correct/restore the Contacts table only as they continued to input appointments, etc for the contacts that were unaffected.  I have backups created by AutoAdmin III prior and post corruption.  The goal is to to load the Contacts into SQL-Server for analysis if possible.

This client has over 6K contacts and extensions to the number of columns (~243 columns).  I don't rememer the PDA brand, but they are using CompanionLink for sync.
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
If you take out the contacts, you won't easily be able to merge them back in.

If you restore a good copy, you can try and import the damaged one - telling it to leave the contacts intact and merge new activities and histories.

You'll need to have some fields the are fairly unique and not damaged to match with
0
AielloJAuthor Commented:
Must resort to a manual process.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Which manual process?

If you think you can do it in Excel, restore the database, use itImport to auto number all the records and export them to Excel from the Contact List (including the auto number field)

Fix them in Excel, then merge them back with itImport using the Auto number field as the match field

You can get itImport from http://www.glcomputing.com.au/main/57/1

This is the easiest way to work on the contact table and not lose all the sub-table links.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ACT

From novice to tech pro — start learning today.