How to migrate Oracle DB to SQL Server

[Eldrik]

Hi,

i need to migrate a oracle database to sql server.

Only tables, procedure, indices no data.

Is there any roundup available?

I know its kind a hard to ask such a question in an oracle forum

Hopefully waiting for a solution.

Greetz
Eldrik

[LKBrwn_DBA]

1) Export the schema:

exp uid/pw owner=MySchema rows=N file=MySchema.txt

2) Get DBATool (free from http://www.databee.com )

3) Generate an SQL script file and edit (modify) to SQL Server specs.

[Eldrik]

thx that tool helped me out

[mrchrispy]

I think you can set up a database link from to the Oracle database and just pull everything across with DTS.

[Eldrik]

i also used DTS but i managed only the tables and there data to sqlserver.

Objects like indices, procedures, constraints are not copied by DTS.

But with DBATOOL vom DATAbee its much easier to get the indices and constraints.