Sign in to follow this  
Followers 0
DjDeep00

Database Diff

4 posts in this topic

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.

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by (^_^)

[center][font="Arial Black"] DESEAN[/font][/center] [center]<<<WOW Fi$her>>>[/center][center]<<<mp3 player>>>[/center]

Share this post


Link to post
Share on other sites

)" 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?

Share this post


Link to post
Share on other sites

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

Search Example Scripts for my Access UDF.


George

Question about decompiling code? Read the decompiling FAQ and don't bother posting the question in the forums.

Be sure to read and follow the forum rules. -AKA the AutoIt Reading and Comprehension Skills test.***

The PCRE (Regular Expression) ToolKit for AutoIT - (Updated Oct 20, 2011 ver:3.0.1.13) - Please update your current version before filing any bug reports. The installer now includes both 32 and 64 bit versions. No change in version number.

Visit my Blog .. currently not active but it will soon be resplendent with news and views. Also please remove any links you may have to my website. it is soon to be closed and replaced with something else.

"Old age and treachery will always overcome youth and skill!"

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0