Post reply

Compare tables of different servers

  • October 8, 2014 at 1:00 am

    #397475

    Hi,

    I have two databases under two different servers.

    Server1:

    DB1

    Table1

    Server2:

    DB2

    Table2

    I need to compare Table 1 & 2 using SQL server and how can I achieve this? Really appreciate any help on this.

  • October 8, 2014 at 4:34 am

    #1750878

    The one tool I've used for the last fourteen years is SQL Compare[/url]. This is such a common task, it makes sense to get a tool that will do the work for you.

    DISCLOSURE: I work for Red Gate, but I've only worked for them for three years. The eleven years before that, I was using their tools.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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