Sql Server 7.0 to Oracle 8i

[santoshym]

Hi

My Question is of two parts

1) Has anybody done a migration of sql server 7.0 schema to oracle 8i schema.Iam talking about transferring the whole structure alongwith the data.If anybody has done please let me know the steps or how they went about to do

2) I have the same structure of tables available in Oracle 8i and SQL Server 7.0.Is there a way in which I can copy only the data from sql server 7.0 table to Oracle 8i tables

I was able to successfully transfer the data from MS-Access to Oracle 8i with the help of Jeff

Hey Jeff or anybody know these steps please let me know

Thanks

[Pinakin]

Not migrated from SQL Server to Oracle. But you can find details at http://technet.oracle.com/tech/migration/workbench/

Good Luck.

Pinakin.

[santoshym]

Hi Pinakin

Iam on Oracle 8i.I Wanted to know tools which will help me for migration.That was a good link

Thanks a lot

Santosh

[aarganesh]

This is a good question, which even I'd to work on long ago, but not on large scale only for a small application. I used Sql Loader to accomplish this task. If there is any other better option please help US.