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

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

mordymordy Posts: 10
edited March 8, 2007 6:39AM in SQL Compare Previous Versions
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

Comments

  • Options
    Mordy,

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

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.