We are looking to migrate from SQL Server to Oracle. The size of current SQL Server databases are around 10TB (About 300 Tables). And, we may not be migrating all the columns from a table in the DB(For example:A SQL Server table may have some 30 columns and we may be moving 23 columns for a given table in Oracle).
SQL - Version 2000
Oracle - 11g
What are the measures for POC?
Can you please suggest the best way to implement this considering the best performance?
PS: I've asked this question in a different forum by mistake.