I need to copy chunks of information from one SQL server to another. One is on a SQL 2000 server, the other is MSDE 2000 sitting on a local machine. I need to be able to copy whole rows at a time, but not whole tables. At the moment I have a rather messy solution where I create two recordsets, one linked to each database and copy info between them. I have created two connections in VB and what I would like is a SQL command that does something like:
COPY WHOLEROW FROM server1.catalog1.tblClient TO server2.catalog2.tblClient WHERE prikey = 7
Is anyone aware of such a command & if it exists does it matter that the servers are on different connections?
Would this question be more appropriately posted in a VB forum?
Thanks in anticipation
Phil
COPY WHOLEROW FROM server1.catalog1.tblClient TO server2.catalog2.tblClient WHERE prikey = 7
Is anyone aware of such a command & if it exists does it matter that the servers are on different connections?
Would this question be more appropriately posted in a VB forum?
Thanks in anticipation
Phil