Re: Easiest way to transfer data from Oracle to SQL Server using a file.
From: joe buhl <joseph.buhl_at_vspan.com>
Date: 25 Jun 2003 08:07:44 -0700
Message-ID: <f87cf429.0306250707.637670db_at_posting.google.com>
Date: 25 Jun 2003 08:07:44 -0700
Message-ID: <f87cf429.0306250707.637670db_at_posting.google.com>
"Linus Nikander" <linus_at_nikander.net> wrote in message news:<It3Ka.6317$GK.113_at_news2.bredband.com>...
> As I stated in my original post i MUST go via a file of some sort so that
> really isn't an option for me. Any suggestions there ?
Yes Mark Powell already posted your solution. Construct a SQL*plus script that generates a delimited file. I think he posted a "how to" link. Then bcp the file into sql server.
jab Received on Wed Jun 25 2003 - 17:07:44 CEST