Migration features of SQL Developer

migrations are setup in 2 primary steps, schema capture and data capture - what you want is pretty simple - just skip the data capture

it has a wizard, you can walk it

it's documented in the help, i've written 2 white papers as well

Jammin wrote:

 

Hi All,

I' d like to use the existing migration features in SQL Developer to migrate

a MSSQL Server db structure (tables, views, procedures, etc...) into a Oracle

db but I'm not interested to migrate the data.

I need to recreate an exact copy of empty db in Oracle with the same structure

with same table, views, procedures....

I am newbie so exists a step-by-step tutorial to do this ?

 

Thanks a lot to all....

 

G.M.

"Database Agnostic Code" is a myth.

Oracle has a completely different transaction model than SQL Server.

Those procedures will need to be reviewed to ensure that they "do things the Oracle way".

Refactoring them into Packages almost guarantees a complete re-write of your application.

My $0.02

MK