Viewing 2 posts - 1 through 2 (of 2 total)
I use 'BCP' to copy data from tables on one server to another server. I use BCP 'out' from the source tables (for each table). For the destination server, I...
August 5, 2005 at 1:54 pm
#580164
The way I accomplish this is create the same table on the other server and execute an insert statement.
delete from TableB (if needed)
insert into TableB select * from ServerA.DatabaseA.dbo.TableA
June 30, 2005 at 9:49 am
#569906