I'm trying to copy data from one server to another. The database I'm copying from is very large and updated daily and I'm interested in just copying the previous day.
Using bcp
I can do this via the queryout
option. Is it possible to set this when using SqlBulkCopy
?
It is not possible to add a WHERE
clause to SqlBulkCopy
. But you can filter the rows that you pass to the WriteToServer
method yourself.