Moving From Oracle to MS-SQL Server

Hi,

I have a customer who wants to move their database from Oracle to MS-SQL Server. On MS-SQL server and can read an ascii file in with BCP. We typically set our data for "|" delimited fields and "\n" for records.

What command would I use to output my data in this kind of format?

field1|field2|field3|......|fieldn
...
field1|field2|field3|......|fieldn

I tried the export function but it only seems to output in some kind of native oracle format. The manual doesn't seem clear on exporting and importing from anything other than Oracle.

Thanks for any ideas,

work_at_timevest.com Received on Fri Sep 18 1998 - 13:33:27 CDT