barrymac
barrymac

Reputation: 2760

Is there a nice shortcut way to export oracle into hssql?

I'm dealing with a legacy database and I'd like to create a test version of it.

It's based on views as opposed to tables.

I'm wondering if someone here knows a nice quick way to export sql from the views with all the data types which I could then use to create a hsql table based version of the database?

Upvotes: 0

Views: 343

Answers (1)

tbone
tbone

Reputation: 15493

You can use most IDEs (Toad or SQL Developer for example) to view and extract underlying SQL from views (and types from snapshot tables). This would be the easiest and most friendly approach.

The alternative would be to use a built in package DBMS_METADATA

select dbms_metadata.get_ddl('VIEW', 'MY_VIEW') from dual;

See here for other options (like 'MATERIALIZED_VIEW') and examples.

Upvotes: 2

Related Questions