This sounds like a job for DTS. The servers do not have to be linked since
DTS runs as a client application. Look into some of DTS's simpler tools and
this should be fairly straightforward.
Regarding point 2: Of course, bcp only inserts data into a target table, so
you could use it if you had the rows copied from the source server.
Regarding point 3: If you create a view in your source database that
defines the rows and columns that you want, you can then use bcp to get that
data set out of the source server.
"Andy" <infoaxxis24.de> wrote in message
news:8cd101c3457f$f12ac120$a401280aphx.gbl...> Hi together !
> I have a problem:
> I "just" wan't to copy some records from server 1 to
> server 2 (same table).
> But here are the problems:
> 1. The servers are not connected (can't use linked servers
> or tion).
> 2. The target table already contains records, so i only
> wan't to insert the new records, and update the existing
> 3. I only wan't to copy some fields and not all records
> from the source table, not all (so BCP isn't really
> What is the best way to do that ?