Comparing Database and Inserting values

Question

Hello Every one,
I am working on databases and I need some advice from you guys.
I have 2 databases with many rows and columns and these db's contain addresses of customers. Lets name the databases a A,B.
Now the problem is I have to search the addresses of B in A using a primary key lets say email.
If the address exist then its ok. Else we have to insert the address in to the other database.
Please tell me how can we do this and which language we can use to do this??
Thank you very much for your time to read my question

Jignesh Trivedi · Answer

hi,
why are you not use any tool for same.
http://www.sql-server-performance.com/2001/database-comparison-sp/
http://www.sql-server-tool.com/
hope this help.

Sam Hobbs · Answer

Also be careful about terminology. Is this for two tables in one database or one table in each of two databases? You say it is for two databases, but I think it is more difficult to do with two databases. As far as I know, it is not possible to write a query for tables in different databases. So if this is for two tables in one database then we do not need to be concerned about writing a query for two databases.
I don't see why you have to search for addresses. Just search for records that don't have an address.
Or are you being ambiguous in saying "address"? When you say address, you mean email address, correct? If not then you need to specify what you mean by address.

subash koutilya · Answer

There are two databases which contain addresses of customers.
From one table we have to take the address of the customer and we have to search for this address in other database.
If we can find the address then its ok.
Else we have to insert this address in the database.

Sam Hobbs · Answer

If an email address does not exist in one table, then will it be copied from the other table or will the email address come from somwhere else? If somewhere else, then will you do this if the email address does not exist in both tables? If both tables, then why do you need to search both at the same time?
You say you "have to search the addresses of B in A using a primary key lets say email" .... "If the address exist then its ok". That is a little confusing becasue if you compare the emaila ddresses and you only want the records where there is not an email adddress, then all the records in one table without an email address will match all the records in the other table without an email address.
So the question is a little confusing.
Tables csn have only one primary key. Are you sure that the primary key is the email address? Probably not. Probably you want to match on the primary key which is not the email address or something else.