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.
TIAApexSQL 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...
>> 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
>