Re: Bulk copy question

I love when people give answers when they dont know what they are talking
about. . .

Its very easy to do!!!

Say we have a server, [source] with a catalog called [foo] and a schema
called [bar] and a table called [foobar]
we have a server called [dest], with a catalog called [fu] and a schema
called [bas] and we want to copy it to a table called [fubas]

first, link the source server as 'foo' . see sp_addlinkedserver (i think
thats the proc) or use enterprise manager.
then simply execute:

select * into [fu].[bas].[fubas] from [foo].[bar].[foobar]

Done!

Works great for importing text too!!!


.

Relevant Pages

  • Re: cocoa and iphoto export
    ... but i dont really have anything but the code ... thats in the tutorial listed in the original post, ... Prev by Date: ...
    (comp.lang.ruby)
  • Re: Wanderer?
    ... "I dont think there would be any ... > on here, but thats about it!" ... I guess that's why you haunt usenet and have done for so long. ... Prev by Date: ...
    (uk.local.hampshire)
  • Re: XBOX 360 FREE to YOU !!! xbox 360 xbox 360 xbox 360 xbox 360 xbox 360
    ... >> you dont say in this message that you have to join some so called offer ... >> thats going to cost you ten times as much as an x-box 360 ... Prev by Date: ...
    (alt.games.video.xbox)
  • Re: im facing problem with fread()??
    ... Rajshekhar wrote: ... > thats it ... > i dont think this file is binary file ..!!! ... Prev by Date: ...
    (comp.lang.c)
  • Re: Poker theory question
    ... thenutlow wrote: ... > but thats the point.. ... you dont know that before you call.... ... Prev by Date: ...
    (rec.gambling.poker)