Exporting Data Using BCP

You may also like...

3 Responses

  1. Stephen says:

    BCP is a great forgotten jewel. One limitation I have run into, is the limit to the size the query can be.

    • I agree, it is often overlooked. I’m guilty of that myself sometimes.

      In order to get around some of the issues with the command line I generally like to either put the logic into a view or of the logic is too complex for a view then use a stores procedure. You can ertainly use the queryout option and just run exec storedprocedure ‘parameter if necessary’.

      I’m doing that exact thing right now for a client to bring over change data capture queries to another server. So far it’s working out great.

  2. Scott says:

    Your queryout example made the day for me 😉

    I had been getting the quite useless bcp errors….

    Thank you, thank you!

Leave a Reply