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

Problem comparing 2005 with 2000 when varchar(max) in source

Been searching for a while but can't find any reference to this problem but I'm trying to compare a 2005 DB with a 2000 DB which is currently empty. The source DB (2005) has some tables with columns that have a type of varchar(max) and these are obviously causing syntax errors in the final script (incorrect syntax near 'max'). Is there a workaround for this ?

Edit: Version of SQL Compare engine is 5.2.0.32
mordy
0

Comments

1 comment

Sort by
  • JonathanWatts
    Mordy,

    Sorry, but at the moment the only workaround is for you to edit the script manually before you execute it.

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.