Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Bulk Load
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 27th July 10:07
bryan
External User
 
Posts: 1
Default Bulk Load


Does anyone know the most optimal way to copy/update data in a table from one
server to another in SQL without using DTS or replication? Are BCP/Bulk
Insert the only options?
  Reply With Quote


  sponsored links


2 27th July 10:07
keith kratochvil
External User
 
Posts: 1
Default Bulk Load


You could use a linked server. You could also use OPENROWSET to access one
server from the other.

--
Keith Kratochvil
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666