What are the challenges you face when working across database platforms? Take the survey

truncate columns

I am trying to update a sql db where the old version has varchar(MAX) columns and the new db has varchar(5000) column size. The script gives a message that data would be truncated and basically fails. I want it to truncate, how do I force the script to complete?

I saw somewhere where you can set Ansi warnings off, but I see no such setting.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    There is no setting in SQL Compare to SET ANSI_WARNINGS OFF. You can save the script to disk, add the set statement to the top of the script, and run it using SSMS or sqlcmd.exe.

    Hope this helps.
Sign In or Register to comment.