Hi everyone,

We are needing to migrate a SQL Server 7.0 Database (which is not at our site, we don't have SQL Server) to an Oracle 8.1.7 Database (unix, aix 4.3.2) we also have some Oracle 8.1.7 Database on our site.

I was looking at using the Oracle Migration Workbench. Questions?

What software will be needed at each location? Do we both need OMWB, SQL Server?

What steps need done on the SQL Server Side?

Would it be easier to migrate to NT and then export the schema to Unix database? Or has someone directly migrated into Unix Database before, or does it matter?

Can SQL Server just supply an export file that we could import?

Any insite would be helpful?
Thanks
Kathy