Re: SQL Server 2000 Migrate to Oracle

C Stabri wrote:

> I am trying to get some tables out of SQL Server 2000 and into Oracle
> 9i. However I am encountering problems.
>
> 1. Many of the tables and column names in SQL server are > than 30
> Characters which meansa any auto inport I do fails.
> Is there a way to get around this.

Yup. Open the relevant table in SQL Server, and start editing the column names.

I'm sure you will tell me there's a perfectly good reason why your column names are so ridiculously long. But I won't believe it, so don't.

> 2.The Create table statements for the SQL database are not
> compatabible with ORacle Create table statements.

Gosh. You mean SQL Server isn't compatible with Oracle?! Stop the presses. Er.... Hang on... Why does Windows complain about my perfectly legitimate "rmdir" command?

Wake up and smell the roses. They are two completely different products from two companies that would rather feed each other to some especially-ravenous crocodiles than co-operate on such matters as compatibility.

Learn each product for what it is, not for how it maps to some other product with which you happen to be marginally more familiar.

> Bascially I need advices on getting 400 odd tables our of SQL server
> into Oracle, any ideas where I have table and column anems > than 30
> chars.

You have a bunch of extraction technologies in SQL Server. You have SQL Loader and Export/Import in Oracle. Use them. Also pay attention to external table technology.

HJR
>
> Thanks
Received on Mon Aug 30 2004 - 06:02:37 CDT