How can we help you today? How can we help you today?

Error syncronizating columns with less length than before

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.
Juan
0

Comments

4 comments

Sort by
  • Michelle T
    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.
    Michelle T
    0
  • Juan
    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.
    Juan
    0
  • Michelle T
    Could you post (or send me at michelle.taylor@red-gate.com) the error message that SQL Compare gives you when the synchronization fails?
    Michelle T
    0
  • Juan
    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.
    Juan
    0

Add comment

Please sign in to leave a comment.