Re: Migrate data from SQL Server to Oracle 8i

Depends on the amount of data. One way to do it is to simply create an ODBC-connection
from SQL Server to Oracle, and then export the tables. However, there may be a problem with
the ODBC-drivers, Microsofts seems to have a problem translating some of the datatypes to
the correct Oracle types.
I used Oracle ODBC 8.01.55 an dit work pretty well , but if the Oracle table existed, it didn't
recognized it, so a new table was created, but the data was written to the correct table, so it left
me with some empty tables to remove! Seems to have to do with upper/lower case.

A personal comment:
If ODBC is the best the database world has come up with as a standad protocol, it's really bad.
Never use it if You don't have to, every manufacturer has its own version(s) and they all behave
different. Really bad!
Regards
/Håkan W

Terence wrote:

> Can any tell me how to do this??
>
> Terence Chow.
Received on Sun Apr 16 2000 - 00:00:00 CDT