In SQL Enterprise Mgr, under Tools - Data Trans Svcs - Export Data -
for dest. pick MS Ole-db provider for Oracle - with a little work you
can create table(s) only - then use something like TOAD to gen the
schema. I've been using SQL 2000 for some time, significant
improvement in DTS since V7.
>
> How can i create my MS SQL Server 7 database schema in Oracle 9i
> database? In other words, how can i migrate MS SQL Server 7 database
> structure to Oracle 9i? I know that i can generate the database schema
> script using MS SQL Server 7 Enterprise Manager but i am not sure how
> and if i can use it to create the same database structure in Oracle
> 9i.
Received on Mon Apr 22 2002 - 09:18:00 CDT
