Easiest way to transfer data from Oracle to SQL Server using a file.

From: Linus Nikander <linus_at_nikander.net>
Date: Tue, 17 Jun 2003 11:24:05 +0200
Message-ID: <Y6BHa.38775$X2.822_at_news2.bredband.com>

Hi, what is the easiest way to transfer a table (including its data) from an Oracle installation (8.1.7) to an SQL Server 2000 one using a file ? I've been looking at using oracle's 'exp' utility to export data, but i can't seem to find any way for SQL Server to import it. Another way would be to export into a CSV file and then import that. All pointers appreciated.

And yes, using a file is a must, I know that all this could be accomplished muche more easily using a db-> db connection but that simply isn't an option.

//Linus Nikander - linus_at_nikander.net Received on Tue Jun 17 2003 - 11:24:05 CEST

This message: [ Message body ]
Next message: robert: "Write PL/SQL query results to a file"
Previous message: news.verizon.net: "XDB port configuration"
Next in thread: James Williams: "Re: Easiest way to transfer data from Oracle to SQL Server using a file."
Reply: B. Jones: "Re: Easiest way to transfer data from Oracle to SQL Server using a file."
Reply: James Williams: "Re: Easiest way to transfer data from Oracle to SQL Server using a file."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message