Compare values of databases between SQL Server 6.5 and 2000

Hi,
I am trying to compare values of two tables which are on different servers
and versions of SQL Server.
All i am looking for is
select * from a where not exists (select * from b where a.docid = b.docid)
where a is a table in Sql server 6.5
where b is a table in sql server 2000
I could not link the databases because of the difference in version. What is
best and easy approach to get the final result.
Vijaya
Hi,
You can simply DTS the table from one server to the other and run your
comparison query.
- - - - - - - - -
Thanks
Yogish
"Vijaya" wrote:

> Hi,
> I am trying to compare values of two tables which are on different servers
> and versions of SQL Server.
> All i am looking for is
> select * from a where not exists (select * from b where a.docid = b.docid)
> where a is a table in Sql server 6.5
> where b is a table in sql server 2000
>
> I could not link the databases because of the difference in version. What is
> best and easy approach to get the final result.
> --
> Vijaya
|||Vijaya,
Can you run the query on the SQL 2000 box? That would work. Or maybe
transfer the table and data from 2000 to 6.5 using something simple like
bcp and run the query locally on the 6.5 box? There's not going to be an
elegant solution to this one.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Vijaya wrote:
> Hi,
> I am trying to compare values of two tables which are on different servers
> and versions of SQL Server.
> All i am looking for is
> select * from a where not exists (select * from b where a.docid = b.docid)
> where a is a table in Sql server 6.5
> where b is a table in sql server 2000
>
> I could not link the databases because of the difference in version. What is
> best and easy approach to get the final result.
sqlsql