Error syncronizating columns with less length than before

JuanJuan Posts: 6
edited October 2, 2007 1:00PM in SQL Compare Previous Versions
Hello,

I have changed the length of a column from varchar(50) to varchar(30), when I try to sync the database, an error is fired about truncated data. I want that data will be truncate, so how can I do it?

Greetings.

Comments

  • Is it an error or is it just a warning?

    We provide a range of warnings, including one about possible truncation of data, to tell people about things that they might not have realised they were about to do to their database. If you know that you want to truncate the data, then you can just continue through the wizard and synchronize, ignoring the warning.
    Software Developer
    Redgate Software
  • Yes, it shows as a warning with a red error icon, I continue with sync, but sync fails; I can't ignore the warning.

    Thanks.
  • Could you post (or send me at michelle.taylor@red-gate.com) the error message that SQL Compare gives you when the synchronization fails?
    Software Developer
    Redgate Software
  • Thank you for your email. Yes, I think that it will be a good idea that I could to select the warnings that I want to ignore, then the syncronization ignores them.

    Thank you again, Juan.
Sign In or Register to comment.