Post reply

migrate a text column

  • June 25, 2003 at 3:07 am

    #81080

    Hi. I have migrated a SQL Server 6.5 to SQL Server 2000 but I have a problem with a text column in a table; my application written in PowerBuilder gives me an error during retrieve of text column in the new database (SQL Server 2000). IS it a bcp problem ? How can i do to transfer correctly values of this column ?

    sop

  • June 25, 2003 at 4:12 am

    #462965

    Not that I know a lot about Powerbuilder, but what is the error you are getting?

  • June 25, 2003 at 4:26 am

    #462972

    I don'to know...but word documents saved in this column can not be opened; the error is "format not valid"; if i create a new doc (in word) and save it in the column (SQL 2000) there is no problem. The problem is only with imported rows with bcp in.

  • June 25, 2003 at 11:20 am

    #463095

    Do you have the original DB or a backup somewhere? If so try installing to another server and do an import using the IMPORT/EXPORT wizard. Sounds like something in your BCP broke the data incorrectly.

  • June 26, 2003 at 4:24 am

    #463198

    But the IMPORT/EXPORT wizard is on SQL 2000 ? there is not a IMPORT/EXPORT wizard in SQL 6.5, is it true ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply