Re: Moving From Oracle to MS-SQL Server

In order to create an ASCII file with the contents of a table, with fields separated by the '|' character, write the following in SQL*Plus:

set pagesize 0
set echo off
set feedback off
set colsep '|'
spool table.txt
select * from table;
spool off

Good luck,

Nuno Guerreiro

On 18 Sep 1998 11:33:27 -0700, work_at_timevest.com wrote:

>
>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 Mon Sep 21 1998 - 05:33:35 CDT