Post reply

How can I compare two values from different Database server?

  • August 11, 2011 at 2:00 am

    #255373

    Hi Friends,

    I'm bignners for SQL and wanted to know how to write query for two different Database server.

    I wanted to compair the data between the two different database server.

    E.g.

    There are 3 DB server those are..

    1. Online DB Server

    2. Admin DB server

    3. Local DB server

    Online DB server has updated data information, every weekend Admin DB server requested Data from Online DB server. Online DB Server sends the Data in XML format and then and then admin convert those xml data into sql format and store into Admin DB server.

    Now I need to compair the Data between Local DB and Admin DB.. like

    1. Display all the records from the two tables (count numbers of records)

    2. Is there any data updated? if yes display only updated records with ID.

    Can anybody advise how to write query for that?

    Your help will really apprititate.

    Thanks & Regards,

    Mahesh

  • August 11, 2011 at 3:02 am

    #1367119

    Hi Stewart,

    Thanks for reply...

    Can you please share example of link server query..?

    Regards,

    Mahesh

  • August 11, 2011 at 3:07 am

    #1367123

    Ok, I'll try with command and will let you know.

    Thanks again..:-)

  • August 11, 2011 at 3:26 am

    #1367134

    Thanks Stewart Once again for your precious help..:-)

  • August 11, 2011 at 3:34 am

    #1367136

    Hi Stewart,

    I did check on the SQL client tool to create a linked server on the LocalDB server, but did not see any option for that.

    Can you please advise how can I achive that?

    Regards,

    Mahesh

  • August 11, 2011 at 5:23 am

    #1367176

    Thanks a TON Stewart..:-)

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply