SEO

#1 (**permalink**) 02-29-2008, 07:26 AM

Hi there,

I've done some searching around on this subject and can't find
anything helpful or non-expensive so far.

I need to export some tables from my companies Oracle server locally
so I can work on a reporting tool which (hopefully) will speed some
things up on our weekly report runs. I know I could just use an ODBC
link and get the data directly from our server but unfortunatly it's
not the newest or fastest of things and these are pretty big reports,
so my idea is to export the tables and run the queries through an
MSSQL database on a faster machine.

However, not being an Oracle or MSSQL developer I'm not too sure how
to export the tables I need. I've looked all over for a script or a
tool to help me do this, but all I have found are tools that cost a
hell of a lot of money, and for something that I don't even know will
work just yet, I don't want to put a PO through for nothing.

I was wondering if anyone has ever used a script that is available or
a GPL'd tool that might help me out here? Or at least point me in the
direction so that I can get started on this.

Thanks in advance for any suggestions

--
Stuart

#2 (**permalink**) 02-29-2008, 07:26 AM

IIRC there is a SPOOL command that will redirect the ouput of a SELECT
statement to a file. It should be fairly easy to import that to MSSQL
using DTS or BCP. However, there are probably several ways of doing
this and I'm not an Oracle expert so for better advice you may want to
repost in an Oracle group.

--
David Portas
SQL Server MVP
--

#3 (**permalink**) 02-29-2008, 07:26 AM

SQL Server DTS is your best bet for this.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Importing from PL/SQL to MSSQL