Re: Easiest way to transfer data from Oracle to SQL Server using a file.
Date: 1 Jul 2003 17:46:57 -0700
Message-ID: <42ddd2f6.0307011646.22ee4f7c_at_posting.google.com>
joseph.buhl_at_vspan.com (joe buhl) wrote in message news:<f87cf429.0306250707.637670db_at_posting.google.com>...
You may try a product called dbwidget (http://www.yazoosoft.com). It
has an unload feature that unloads a tables data definition language
and creates insert statements for the data in the table. It works
with several different
> "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
databases including Oracle and MS SQL Server.
Received on Wed Jul 02 2003 - 02:46:57 CEST