Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Maryland
    Posts
    17

    Unanswered: Trouble bcp'ing from Unix to Windows

    Hello all,

    I've been asked to migrate a database from a Sybase 11.9.2 DEC Unix system to a Sybase ASE 12.0 Windows 2000 Server system. Most of the tables bcp out, ftp, and bcp in just fine, but I have some tables with text fields that are causing me problems, even with -T set (to any value). I get the following message:

    "Text/image field is larger than the maximum value. Data truncated."

    Then the process just hangs, so I have to kill it. Any ideas?

    Thanks,

    Bill

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    I hope you are using bcp -c option. Also, when bcping out text or image columns, a column and row terminator must be selected that does not appear in the text/image columns, i.e. -r and -t options.

    HTH.

  3. #3
    Join Date
    Aug 2003
    Location
    Maryland
    Posts
    17

    Thanks mkalsi

    I was using the -n option. Changed it to -c, added field and row terminators, and it worked great. Thanks - you're a life saver!

    Bill

Posting Permissions

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