Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    6

    Question Unanswered: [HELP!] what's the safe way to export tables(only Data) to file?

    Hi:
    I'm want to export some tables(only data) to file and import it to another DB. Does anybody know that what 's the most safe way to do it? Because I have some binary data in these tables, I don't think I can export it to .txt or .csv format.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can use the BCP command line utility to import and export image and text data. You can also use DTS, but in DTS there is an upper limit to the image field size.

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •