SQL Server to Oracle

[Guest_imported]

I need to convert a database from SQL Server 7.o to Oracle. The (only?) way I think on doing it is to generate a SQL script from sql server, and them manually edit it to suite Oracle's datatypes and then use it to create the DB on Oracle.

My questions are:

-Is there any way on doing this automatically, maybe some application will do this?

-If this is the only way, where can I get a list o correspondences between SQL Server and Oracle's datatypes?
(I mean for example which is the SQLServer's smalldatetime datatype in Oracle)

tia

 

[MrJC]

Hmm,

You could DTS it across - but I've had (some) experience with Oracle to SQL and found that Boolean types caused the most grief (esp since it was a large Dbase and I couldn't locate details of the table structures

Jon

 

[Guest_imported]

DTS it across? I don't know if this would work, booleans are problematic, but I could change all booleans datatypes to integers on the sqlserver side, that shouldn't be an issue, but datatypes like smalldatetime would cause problems also no?