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?

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

--
Keith Kratochvil

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

1 27th July 10:07 bryan External User Posts: 1	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?

2 27th July 10:07 keith kratochvil External User Posts: 1	Bulk Load You could use a linked server. You could also use OPENROWSET to access one server from the other. -- Keith Kratochvil