Database Diff

[DjDeep00]

I want to make a program that will compare two tables in a database and return the differences. In my case I want to be able to create a snapshot of a table for a specific schema and save it on the computer and then be able to take that snapshot and compare it with same table. (Before and After) What is the best way to get that snapshot and what file format? For connecting to the database and getting results back I am currently using ObjCreate( "ADODB.Connection" ). Is there any other faster or better way to connect to the database?

Any suggestions would be a great help. Thanks in advance.

[(^_^)]

I want to make a program that will compare two tables in a database and return the differences.

is it numbers that its comparing? cuz my decypter compares numbers im just not sure how to work the get strings very well, cuz i only have a bit of exp with strings

p.s and if u want it to compare words just have it get the string and put it in a

if $text1 <> $text2 then

FileWrite("file name", "Differece from database 1" $text1 "from database 2" $text2) ;--- to save the differences

endif

Edited February 25, 2007 by (^_^)

[DjDeep00]

)" data-cid="310216" data-date="Feb 25 2007, 01:05 AM">

is it numbers that its comparing? cuz my decypter compares numbers im just not sure how to work the get strings very well, cuz i only have a bit of exp with strings

p.s and if u want it to compare words just have it get the string and put it in a

if $text1 <> $text2 then

FileWrite("file name", "Differece from database 1" $text1 "from database 2" $text2) ;--- to save the differences

endif

Kool thanks. Anyone else have any more suggestions?

[GEOSoft]

Open 2 recordsets (1 for each table) and use a query to compare the strings.

Search Example Scripts for my Access UDF.