DjDeep00 Posted August 15, 2007 Posted August 15, 2007 Not sure if there is a way to find out the differences between two tables using a sqlite database. I didn't see any function in the sqlite helpfile regarding this, just wanted to know if anyone could help me with this?
ptrex Posted August 15, 2007 Posted August 15, 2007 @DjDeepOOYou will not find any function for this, because to find the differences you will have to use "SQL Joins"See here for you first steps into joins : SQL Joinsregards,ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New
DjDeep00 Posted September 21, 2007 Author Posted September 21, 2007 Ptrex, Here is what I am trying todo. Get data from two tables in Oracle and find out what the differences are between them. I would like to extract the Oracle data using ODOR into Sqlite (for some reason the inserts are really slow) or Access (not sure how to do this?). I just want the fastest way of doing this task. I tried exporting to a text file and writing my own diff functions but these tables are huge so it takes like days for the diff to complete. So i figured importing the data into a another local database and then doing the diff would be faster. Like you mentioned that I should use the sql "Join", I understand the syntax of it but not sure how I am gonna get back the differences by row and column? Please advise. Thanks in advance, DjDeep
guwguw Posted September 22, 2007 Posted September 22, 2007 DjDeep00 said: Ptrex,Here is what I am trying todo. Get data from two tables in Oracle and find out what the differences are between them. I would like to extract the Oracle data using ODOR into Sqlite (for some reason the inserts are really slow) or Access (not sure how to do this?). I just want the fastest way of doing this task. I tried exporting to a text file and writing my own diff functions but these tables are huge so it takes like days for the diff to complete. So i figured importing the data into a another local database and then doing the diff would be faster. Like you mentioned that I should use the sql "Join", I understand the syntax of it but not sure how I am gonna get back the differences by row and column? Please advise.Thanks in advance,DjDeepWhy don't you perform this task under Oracle itself? That should be much more efficient than any other way.Next efficient solution would be to read the Oracle data into memory (array) and compare them from there with the second table, writing only the differences to a file.
DjDeep00 Posted September 24, 2007 Author Posted September 24, 2007 Quote Why don't you perform this task under Oracle itself? That should be much more efficient than any other way.-I dont have access to the Oracle tools and I only have read-only access to the oracle database. Quote Next efficient solution would be to read the Oracle data into memory (array) and compare them from there with the second table, writing only the differences to a file.-As I stated earlier... Quote tried exporting to a text file and writing my own diff functions (using Arrays) but these tables are huge so it takes like days for the diff to complete.-The biggest problem with this was the speed. Some tables have around a 500,00 rows or more.
jchd Posted July 15, 2022 Posted July 15, 2022 There's also the sqldiff.exe program available from the SQLite team: https://www.sqlite.org/sqldiff.html Reveal hidden contents This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
Developers Jos Posted July 15, 2022 Developers Posted July 15, 2022 (edited) On 7/15/2022 at 12:06 PM, Konstantin-S said: I am the author of these tools. Expand So you registered for free advertisement? The thread has a grey beard like me! Edited July 15, 2022 by Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past.
Recommended Posts