truncate columns

Forum for users of SQL Compare schema synchronization utility

truncate columns

Postby » Wed Jan 29, 2014 11:46 pm

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.

Posts: 1
Joined: Wed Jan 29, 2014 11:40 pm

Postby Brian Donahue » Mon Feb 03, 2014 10:07 am

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest