question

You have this tagged as 2005, so you may want to consider SSIS instead of BCP. SSIS tends to do many of the same things as BCP, but it is more user friendly and (at least for certain tasks) more effecient. Moving data between two instance of SQL Server that are both on the same domain is one area where SSIS will tend to shine. But if you want to use BCP, I do not believe there is a way to directly move data from one instance of SQL to another. You can however do it indirectly by using BCP to export the data to an interemediate file, and then use BCP again to import it from that intermediate file into your other instance of SQL Server. BCP is a command line driven program, and I can't really give you a good example without a lot more details, but the general syntax and some samples are availabe on [MSDN][1]. [1]: http://msdn.microsoft.com/en-us/library/ms162802.aspx