Exporting Data and Table Structure from Oracle to SQL Server

[Nilesh_S_Gokhal]

Hi Guru's,

I have to export the table structure and data from Oracle to a Script file.
Which will be imported later on into SQL Server through a front end tool.

Is there any way I can get the DDL of a table in SQL Server format??


Thanks in Advance.

[Shuja Ali]

I think you can use Data Transformation Services of SQL Server to get the table and data from Oracle to SQL.

Have you tried DTS?


I have been posting only about DTS

[Krzemo]

Is there any way I can get the DDL of a table in SQL Server format??

If for some reason U choose not to use DTS , than U can just export it in any tool U have. Since DDL is quite similar in both RDBMs than all U have to do is Seach&Replace

Best regards,
Krzemo.

[dba2000]

We have very large tables in Oracle 9i and moving data daily to SQL Server with Fastreader. DTS works well though when you have small data sets. We couldn't use it. Fastreader quikly extracts data into plain text files also creates schema definition and loader to sql server among other databases

fastreader : http://www.wisdomforce.com

Hi Guru's,

I have to export the table structure and data from Oracle to a Script file.
Which will be imported later on into SQL Server through a front end tool.

Is there any way I can get the DDL of a table in SQL Server format??


Thanks in Advance.