RE: migration from Sybase to Oracle

2003-01-30 Thread Adrian Roe
Best option is to use bcp to get the data out of Sybase ino a flat file, then use SQL*Loader to get the data into some Oracle staging tables. You can then use pl/sql procs to move the data to it's final destination. Ade -Original Message- Sent: 29 January 2003 12:49 To: Multiple

Re: migration from Sybase to Oracle

2003-01-29 Thread Stephen Evans
vijay, oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects data from sybase to oracle. however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you