[UPHPU] Merging two databases.
Ash
ashovi at qwest.net
Mon Sep 28 09:00:03 MDT 2009
I have two separate databases that have client info in them, one is
mysql and the other is in MSSql. I need to send an email to them about
the info in the db. The problem is that the email address is in the
MSSql db and the info they need to change is in the mysql db. There is a
common field between the two which is their customer number.
I have control over both boxes, and was thinking I would just export
both of them and combine them into one database that has all the info in
it, and then send the email out, but thought I'd see what you gurus
thought about it.
Here are a few more specifics:
MSSql contains the email address and the customer contact info.
Mysql contains the contact's client list and customer number. The info
we need to send them is the NCOA and CASS (address change/correction)
info from the USPS. The only common field between the two is the
customer number. So we have customer #100 and he has 30 bad addresses in
the mysql database. I want to make a script that will grab the 30 bad
addresses and email it to the client to tell them to update it. The
script shouldn't be too hard, I'm just wondering the best way get to the
data.
Ash
More information about the UPHPU
mailing list