Does it put " 's around all the tables and column names? If so don't use it
as it will cause you a lot of grief later on.
Jim
"m. fowler" <mfowler_at_dot.co.pima.az.us> wrote in message
news:e9c5a67.0204220618.42f005c0_at_posting.google.com...
> 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:49:41 CDT
