2012年3月19日星期一

bcp in/out Oracle Linked Server

Is this possible?
Has anyone done this?
Any comments appreciated.Brett:

Sorry for being thick, but your question wasn't entirely clear to me:

Are you trying to use BCP on a linked Oracle server to dump a file from a command in SQL server? or

Are you trying to bulk load a table in Oracle with data in SQL (and vice-versa)?

Regards,

hmscott|||bcp out is possible:

you can create a procedure/function/view referencing the ora object and use queryout with your bcp using your procedure/function/view.

i haven't tried bcp'ing in into a linked server yet, but you can do a test yourself, right ? ;)|||Guys,

Thanks...

Sorry for not being clear...

I want to set up a generic (yes...dynamic sql against the catalog) to bcp out all tables (and gener format cards for fixed width).

That's built for sql server.

I want to establish a linked server, and point the sprocs at the linked server (Oracle, udb, whatever).

I was hoping to avoid queryout (that's why I gener the format cards)..

And yes, I can (and will test) the bcp back in...

I'm thinking I might have to gener view of the tables on the linked server..

Another question, how do you reference INFORMATION_SCHEMA of another database (in this case the linked server) from the context of the database you're in?

EDIT: Other responses http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31183|||Originally posted by hmscott
Brett:

Sorry for being thick, but your question wasn't entirely clear to me:

Are you trying to use BCP on a linked Oracle server to dump a file from a command in SQL server? or

Are you trying to bulk load a table in Oracle with data in SQL (and vice-versa)?

Regards,

hmscott

fyi...It's SQLLoader in Oracle...

没有评论:

发表评论