Specific tables from MSS to Oracle

Hi Vitaliy,

Thank you so much for your help. I really appreciate it. God Bless you!

Here is one scenario...Please help me with it.

I have 2 databases, A and B.
A has MSS in it and filled with data. B has Oracle in it and is empty with a 
particular schema.
Now, I want to do some testing with some scripts injection in a new 
intermediate database (Oracle) which will be named as C since I do not want to 
mess up with A and B.
In order to do so, I want to copy some specific tables from A (MSS) to C 
(Oracle) and export the schema from B (Oracle) to C (Oracle).

Please guide me the steps to proceed. Thanks again!

Regards
Muddu

If this is a one-time thing moving database from MSS to Oracle, then check 
these two writeups where you can use SQL Developer to export database from MSS 
to Oracle:

   Migrating a Microsoft SQL Server Database to Oracle Database 11g
   Migrating from Microsoft SQL Server to Oracle

Otherwise, if this is going to be an on-going automated data move, then 
research Oracle Transparent Gateway for Microsoft SQL Server:

   Installing and Configuring Oracle Database Gateway for SQL Server

Once you finalize how to get MSS data into Oracle, you can use Oracle's expdp 
to move the schema from one Oracle Database to another, or you can develop 
PL/SQL procedures to do that if you need to do some transformations.

Yes, I have gone through that documentation. It depicts the migration of the 
entire mss database while I just wanna move some specific tables to Oracle. Not 
sure how to use Oracle SQL Developer to move some tables from MSS to Oracle. 
Please advice.

Thanks

> Yes, I have gone through that documentation. It depicts the migration of 
> the entire mss database while I just wanna move some specific tables to 
> Oracle. 

Yes that example is for migrating an entire database.  SQL Developer will 
create all required DDL to create database and tables, but it's up to you what 
you do with these scripts.  You can just decide not to create a whole new 
database but instead create few tables ...

> Not sure how to use Oracle SQL Developer to move some tables from 
> MSS to Oracle. Please advice.
> 

I don't have access to MSS to test my theory, but I am pretty sure you can pick 
and choose what you want to do with DDL scripts SQL Developer generates.  So 
just go through the process and only "keep" the tables you want.  SQL developer 
will do all the work for you, it will:

  - generate DDL (you'll run it on ORACLE to create empty tables you need)
  - export data in flat file format
  - generate sqlldr control files to load them into ORACLE

Sounds doable to me -- just go through it and see what happens.

Alternatively, install the gateway and pull the data VIA dblink (gateway will 
allow you to create a DBLINK to MSS).

Thanks much Vitaliy,

I have migrated the complete MSS Database to Oracle via the OTN link which uses 
SQL developer as the migration medium.

Anyways, I have also got a migration tool (cracked) from one of my friends. 
EasyForm DB Migration tool which works like a charm!!

Regards
Muddu