Can anyone tell if it is possible to use bcp command to insert data directly from a [Server1].[Database1].[Query] to another [Server2].[Database2].[Table] directly ? I can only find references to Query to File and File to Query. Thanks
Mar 13 at 11:34 AM
Mar 13 at 09:09 AM
@wbeetge Why do you need bcp? It is trivial to insert records selected from the database table in one instance to the table in another instance via openrowset. Please clarify the reason. Thank you.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
sql server x261
asked: Mar 13 at 11:34 AM
Seen: 17 times
Last Updated: Mar 13 at 02:57 PM
invalid buffer size for BCP column property
bcp / Bulk Insert difference
How do I INSERT or UPDATE an array of values without iteration?
BCP - Text data and Identity columns
ms sql server clustering
SQL SERVER REPLICATIOn
Hiearchy of an objects qwith multiple parents and childs from different sources
after installing the server, you restart the computer.
Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
How to call Stored procedure in DTS defined on a sql server and use output parameter value as i/p to stored procedure in different SQL server