Solved

Oracle Question

Posted on 2013-02-05
6
363 Views
Last Modified: 2014-05-27
I am migrating a certain table from an old application (oracle 9 database) to a new application (ms sql server). I queried this table in our oracle database and there is a total of 1439 rows. How can I validate this data to ensure that all data was transfer from the old application to the new application. I only have access to the oracle database and not the ms sql database. However I do have access to the new application that also displays the total count of 1439.
0
Comment
Question by:TexanDonnaP
  • 2
  • 2
6 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 38855844
Since you don't have database access to the SQL Server database:

Personally I would select a few rows that have all columns pouplated and a few where some of the fields are at their maximum length (a varchar2(10) has 10 characters in it, a number(4) has 4 numbers),

Then use the app to locate them.

Can you possible get the DBA on the SQL Server database to create a Text file extract of the table?
0
 

Author Comment

by:TexanDonnaP
ID: 38855849
I think i can get access to the SQL server. Let me download toad first.
0
 

Author Comment

by:TexanDonnaP
ID: 38855958
So I now  have access to the MS SQL database.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38855984
I've not used Toad much but it looks like it can do the compare for you:
http://www.toadworld.com/Blogs/tabid/67/EntryId/540/Toad-s-Most-Overlooked-Feature.aspx

Comparing Data between Tables
If you need to compare data between two different sources, Toad for Data Analysts provides an extremely straightforward wizard to accomplish your task.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now