Comparing Database

[LeonTang]

Hi,

Is there anyway that I can compare 2 database in visual basic? That means checking for the same table names and column names within each table. Btw, I am using DAO.

Thanks for your time,
Leon If you need additional help, you can email to me at zaoliang@hotmail.com I don't guaranty that I will be able to solve your problems but I will try my best

 

[anderung]

There are probably many ways.
You can create two ODBC connections to the different databases.

Retrieve a recordset from both and compare the results of the resordsets. e.g
conOne.open "firstODBC","signin"
conTwo.open "secondODBS,"signin"
set rstOne=conOne.execute("selext yourColumn from yourTable&quot
set rstTwo=conTwo.execute("selext yourColumn from yourTable&quot
Then you can easily compare the results by using
rstOne!yourColumn=rstTwo!yourColumn
KR/Anette

 

[LeonTang]

Thanks for your reply. But that wasn't actually what I was looking for...

I know that I can loop through the tables within the database and inturn loop through the columns within the tables. But are there any shortcut to it?

Perhaps something like comparing the tabledefs of the 2 database?

Thanks again,
Leon
If you need additional help, you can email to me at zaoliang@hotmail.com I don't guaranty that I will be able to solve your problems but I will try my best