DTS Sequel Database to Oracle with no Live connection

#1

Anyone,

I normally work under Oracle, however I have a requirement
to send a Sequel Database to a Oracle Client. I do not
have online access to the Oracle database, so the DTS
packages using OLE-DB etc cannot run.

Is there any way of exporting the Database without a live
connection ( I am sure there is but I cannot see it right
at this moment)

In anticipation

Thanks

Paul

#2

Exporting the database to what ?

These articles have a raft of issues you may see. Most of them involve
coming the other way from SQL Server to Oracle but you will get the idea.

http://search.microsoft.com/search/r...u=oracle&na=30

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Paul Blackler" <pblackler (AT) themis (DOT) co.uk> wrote

Quote:

Anyone,

I normally work under Oracle, however I have a requirement
to send a Sequel Database to a Oracle Client. I do not
have online access to the Oracle database, so the DTS
packages using OLE-DB etc cannot run.

Is there any way of exporting the Database without a live
connection ( I am sure there is but I cannot see it right
at this moment)

In anticipation

Thanks

Paul

#3

I would export all my tables to text files then. You can then have them
Import these at their end using SQL Loader.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Paul Blackler" <pblackler (AT) themis (DOT) co.uk> wrote

Quote:

Hi Allan

Thanks for the reply, what the problem is, is that a
client of ours running Oracle wants to import our SQL
database to see the structure and data, that is all.
I was hoping to use DTS, to export our DB but it seems
that it wants to have access to a live Oracle connection,
which is something that we dont have access to.

Any ideas

Cheers Paul

-----Original Message-----
Exporting the database to what ?

These articles have a raft of issues you may see. Most
of them involve
coming the other way from SQL Server to Oracle but you
will get the idea.

http://search.microsoft.com/search/r....aspx?View=en-
us&p=1&s=0&c=4&st=b&qu=oracle&na=30

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Paul Blackler" <pblackler (AT) themis (DOT) co.uk> wrote in message
news:068601c3656b$e67243a0$a401280a (AT) phx (DOT) gbl...
Anyone,

I normally work under Oracle, however I have a
requirement
to send a Sequel Database to a Oracle Client. I do not
have online access to the Oracle database, so the DTS
packages using OLE-DB etc cannot run.

Is there any way of exporting the Database without a
live
connection ( I am sure there is but I cannot see it
right
at this moment)

In anticipation

Thanks

Paul

.

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

DTS Sequel Database to Oracle with no Live connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Sequel Database to Oracle with no Live connection - 08-18-2003 , 04:34 AM

Re: DTS Sequel Database to Oracle with no Live connection - 08-18-2003 , 05:46 AM

Re: DTS Sequel Database to Oracle with no Live connection - 08-18-2003 , 06:52 AM