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

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


  • Options

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


    Jonathan Watts

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