05-27-2009 09:51 AM
ok, So i am having a problem exporting data from one database to another. Im on Act Premium 11
I have 2 databases, Database_A and Database_B. Im trying to export ALL the data from Database_B into Database_A. Sounds easy...right? in Database_B i just goto export, choose all records and export it into Database_A. i have duplicate checking OFF in BOTH databases (becuase i dont want it to merge, or do anythign with any of the records, just simply add them together,even if there are dup's)
In the export wizard I've tried both "merge" when duplicate is found, and "Add" when not found. Also, tried "Do Nothing" when duplicate is found, and "Add" when not found.
In BOTH cases it only added 26 from database_B to Database_A (it should have moved 500+) Since it only moved 26 over, I have the feeling that it is finding matches and "merging" or "doing nothing". although im 100% that there are NO matches in either Database. And even if there were, I dont have Duplicate checking on.
How do i make sure it does not find matches!?! I just want to add the Databases together, matches/duplicates and all.
What am I doing wrong?
05-27-2009 10:07 AM
05-27-2009 10:12 AM
No, the Source database (Database_B) has about 500 records. The Destination Database (Database_A) has about 12,000 records.
Is there ANY way to add these two Database's together? what give a records its unique ID?
05-27-2009 10:25 AM
05-27-2009 10:37 AM
you said "I would have to assume that most of the 500 records were already in the 12,000 record database."
I agree in a sense. I think that it THINKS that the records are already in the destination database. but they are NOT. a lot of the records and such have missing info, so i think it reads 2 records NOT having, say phone numbers just for example, are a MATCH. When really they are not, just imcomplete. My understanding was, if i turn Duplicate checking OFF, that it would just simply ignore what it THOUGHT were duplicates/matches and just add them to the database.
Is my train of though on the right path? or am i missing something? I hope i am, so i can fix this!!!
05-27-2009 02:05 PM
05-27-2009 02:18 PM
i just did the empty master thing. It worked. All the records went over to the empty master. Why did i Do that?
so now we know the export is working.
this is very frustrating. What are the chances that 95% of my records are matching by unique ID in the other Database? if it were 1-10 records i wouldnt care, but almost ALL of the records are getting matched to something, even though the Dup checking is off.
05-27-2009 02:50 PM
05-27-2009 03:28 PM
hey hey hey!!!!! looks like youre right!
A while back, a coworker exported a look-up into a new database (database_b) and changed the info in the records. So the names of companys and such were different, but they came from the Database_A. So i guess the unique ID's were the same.
thank you soo much for troubleshooting this with me. I owe you one.