Is anyone aware of software - freeware, shareware or commercial - that could
be used to compare two tables and highlight any differences between them?
Ideally, such a tool wouldn't care about operating system or database
version so that I could compare, say, a DB2 V8.2 table from DB2 on
Linux/Unix/Windows with a DB2 V7 table from OS/390 but that's not
necessarily an absolute "must-have" feature.
I would imagine IBM has tools like this for their internal testing of DB2
but I'm not sure if these tools - or their commercial equivalents - are
available to the public.
Can anyone enlighten me?
--
Rhino 6 3018
Rhino,
There are quite a few commercial and open source products that will do
this - too many to list.
Alternatively, it isn't difficult to write one yourself - if you're
familiar with a simple language like bash, python, etc:
1. pass arguments for two databases, schemas, tables, userids,
passwords
2. export from each to local files
3. get a count of lines different: count=`diff local.dat remote.dat
| wc -l`
4. remove temp files
5. report back number of differences
Of course you could keep the diff output to see the exact lines
different.
"kenfar" <ke****@gmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com... Rhino,
There are quite a few commercial and open source products that will do this - too many to list.
Can you list a *few* of them? Or a generic term that will produce suitable
hits from a Google search? I haven't had much luck yet with Google, which
usually doesn't let me down. I thought "table comparison software" would get
many relevant hits but that wasn't the case.
Alternatively, it isn't difficult to write one yourself - if you're familiar with a simple language like bash, python, etc: 1. pass arguments for two databases, schemas, tables, userids, passwords 2. export from each to local files 3. get a count of lines different: count=`diff local.dat remote.dat | wc -l` 4. remove temp files 5. report back number of differences
Of course you could keep the diff output to see the exact lines different.
Yes, I'd thought of that approach but, before "re-ineventing the wheel", I
thought I'd see what already exists to do the job for me.
Rhino
Hi,
Rhino schrieb: "kenfar" <ke****@gmail.com> wrote in messageThere are quite a few commercial and open source products that will do this - too many to list.
Can you list a *few* of them? Or a generic term that will produce suitable
search freshmeat.net for "diff".
diff is part of every standard linux or unix distribution I am aware of.
db2look + diff + 5 Minutes of scripting should do the job.
Alternatively, it isn't difficult to write one yourself - if you're
Yes, I'd thought of that approach but, before "re-ineventing the wheel", I thought I'd see what already exists to do the job for me.
No, you are not reinventing the wheel. diff IS the wheel. You are
thinking about reinventing a bike for a 10yrds-run. ;-)
If you want it coloured and clickable, search freshmeat.net.
tcb,
Norbert
On Windows, the DOS command fc will do the job as well.
B.
Are you looking for schema comparison or data comparison? I'll assume
schema as the question seems to lead that way.
BMC has SmartDBA Cockpit, free annual renuable license. It has a DDL
compare feature. Patrol Change Manager is much more comprehensive and
will generate scripts to sync one version to another.
Embarcadero's DBArtisan has a visual diff too. Licensed product.
You might use a DB2LOOK and ExamDiff from purestyle (freeware
version).
These are just some of the many tools out there.
R > Is anyone aware of software - freeware, shareware or commercial - that could
R > be used to compare two tables and highlight any differences between them?
Edward Lipson via Relaynet.org Moondog ed***********@moondog.com el*****@bankofny.com
---
ž MM 1.1 #0361 ž
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Rhino,
SchemaCrawler is written in Java, and is a command line tool, with an
ant task too. It can dump your database schema (metadata), as well as
data into a text file (plain text, CSV or XHTML). All of these text
file formats are designed to be diff-ed. (You will need to use your
favorite diff tool to do the diffs.) It is platform (database and OS)
independent.
SchemaCrawler is open source, and hosted on SourceForge. http://sourceforge.net/projects/schemacrawler/
Sualeh. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: democratix |
last post by:
Hi,
I've only got a couple years experience developing for Access but have
recently been experimenting with HTML/javascript for gui and
client-side scripting, mysql for database and php for...
|
by: jonathan |
last post by:
hey all,
I realize that this question might pop up from time to time, but I
haven't seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in...
|
by: Generic Usenet Account |
last post by:
Does anyone have an opinion on how IDL and WSDL compare to each other?
Are they equally powerful in their "expressive power"? Sometimes it
appears to me that IDL is a little easier for humans to...
|
by: bettervssremoting |
last post by:
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere,
SourceOffSite, VSS...
|
by: mayamorning123 |
last post by:
A comparison among six VSS remote tools including SourceOffSite ,
SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
To view the full article, please visit...
|
by: Doug |
last post by:
Hello,
Can anyone recommend an inexpensive source code comparison utility for .NET.
I broke my code an now I need to compare my older version w/ the new one and
could use the help of line...
|
by: Johan Tibell |
last post by:
I would be grateful if someone had a minute or two to review my hash
table implementation. It's not yet commented but hopefully it's short
and idiomatic enough to be readable. Some of the code...
|
by: foolproofplan |
last post by:
I have a situation where I need to convert an xml file into two types
of tables in html. I have never done anything like this before, so I
have been reading up on it online. However, I am not 100...
|
by: ravi |
last post by:
Hi
can anybody tell me that which ds will be best suited to implement a
hash table in C/C++
thanx. in advanced
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |