compare Data in 2 databases?

Hi All
I am relatively new to coding so please bare with me...
I have a number of SQL 2005 databases I access using an ODBC connection.
What I would like to do is create a code of some kind that will look at the
Client List in one db <<server1>> and compare them to like fields in another
<<server2>>. I would like this to then be a View that I can connect to with
Crystal and build a report around.
This is probably brain dead stuff to you but I am not finding what I need in
the NG's, but I am probably not calling it the correct term.
TIA
ApexSQL has a Diff product that can compare both data and structures. I
believe you can output the results of a compare for use elsewhere.
TheSQLGuru
President
Indicium Resources, Inc.
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>
|||There is not statement that I can write that will do this? I am in a
non-profit and cannot buy all of these add-ins.
Thanks
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>
|||John,
If your database is not too big, the free Lite Edition:
http://www.xsqlsoftware.com/LiteEdition.aspx
Advertised as free for SQLExpress:
http://www.teratrax.com/tdc/?gclid=CLGX5YD4-o0CFUtyOAodnRSlOw
Red Gate tools also come with a 14-day trial as do doubtless others.
RLF
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:368D850F-0CC0-4919-8D99-BE1936935556@.microsoft.com...
> There is not statement that I can write that will do this? I am in a
> non-profit and cannot buy all of these add-ins.
> Thanks
> "JOHN HARRIS" <harris1113@.fake.com> wrote in message
> news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
>