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...
没有评论:
发表评论