Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration problem: SQL Server to Oracle

azizMar 4 2012 — edited Mar 7 2012

Windows 2008
Oracle 11.2.0.2

I am migrating sql server 2005 database to Oracle 11g. I migrate with no error, but when I compare tables from both system, I am getting inconsistant count. Majority of the tables are consistant, but two or three is getting this inconsistant numbers, including the example below.

EXample:

Oracle-
select count(*) from tblcasefile;

I get 3770 counts

SQL Server-

select count(*) from tblcasefile:

I get 3803 counts

Any idea from here?

This post has been answered by jgarry on Mar 6 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2012

Added on Mar 4 2012

#general-database-discussions

26 comments

771 views