• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

Table Data Compare - Oracle to MS SQL

I have exported data from Oracle Database to MS SQL database using export wizard. Now i want to compare data of both database (not total number of rows) that is data is exported properly or not (row-by-row) manually.my table contains thousands of records. It is difficult to compare row by row and column by column.

Is there any scripts/third party tools available for my above requirement?

If any one having script, please share it.

Thanks in advance.
  • 2
2 Solutions
In most cases it's enough to check a few values (non-ascii characters!), rules, procedures, number of rows, etc of a few tables.  If you want to be absolutely sure you need a independent way to read and compare. For just the data, a script would do nicely, vbscript, php, vba (access), anything. There are some  tools to compare schema's, like DBSolo (dbsolo.com), and many more.
You can select * from tables in source as well as target and redirect output to text files and compare in text editors like TextPad.

You can also select comma delimited data from entire table by converting all columns into strings and concatenating, redirect/save as .csv, open in excel sheet and compare using excel compare tools.

Excel Compare (latest version is 8.0)
Excel Compare - Program description
Compare and merge your Microsoft Excel spreadsheets with a single click
Software Search Forexcel compare

You can also directly compare schema tables data once connected to database(s) using database tools:

DB Explorer
CDB Database Comparator

Now, if tables structures is same, then all above solutions do apply. If there is some column mapping involved and transformations, you need to write corresponding queries to extract correct data into text/excel files. Above Database tools can help directly.

Some more are:
Data Migration Assistant (DMA) Release 6.1(1a)
Data Validation
This 'converting to text' will change the non-text data; the two databases may do that (slightly) different, and generate a lot of false hits, or not at all, and give you a false sense of security.
I would still advice a script or tool to compare the data in it's original type.
Unless it's all text and not too large to import into Excel or a editor. Maybe.
srinivas_ganamurAuthor Commented:

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now