conveting data from mssql 6.5 to oracle 8.0.5?

Hello:

I will be working on an application that will be converted from mssql 6.5, sp 4 to Oracle 8.0.5.

Ahortly, I will need to load start loading data from the mssql 6.5 application to oracle 8.0.5. There is no text data or anything else thatcoul be called more complicated o exotic. Just datetime, char and varchar.

I am looking for information on :

1. how can I take a tables'data loaded out with bcp under mssql 6.5 and load that data(and format) file into an Oracle table? Do I need to convert each bcp \'s format file to a control file for slqloader to use?
2. If I use workbench migration utility, version 1.22, has any one used that utility to load daat from a sql server 6.5 table to an oracle 8.0.5 table? Are there any issues involved?
3. Someone mnetioned to me that there may be issues with converting a date feied from sql server to oracle and the data field is converted to varchar2? Has any one experienced this?
4. Has any used DBArtisan's unload and load functionality across sql server and oracle? Any problems?
5. Are there any other utilities available?
6. Has any one converted mssql 6.5 data to oracle8.05? any other significant problems? Any other data type problems

Any information that can be provided will be greatly appreciated. Thank you.

David Spaisman Received on Sun Mar 19 2000 - 19:28:20 CST