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

MSSQL 2005 support

MartinHMartinH Posts: 82 Bronze 2
edited July 28, 2005 2:00PM in SQL Compare Previous Versions

I am working on a project that will not be released before the end of this year, but when it is released it will be for MSSQL 2005, so we want to start doing our development with Visual Studio 2005 (beta 2) and MS SQL 2005 (beta 2).

Can you tell me if I can use the current version of SQL Compare with this setup? If not, when can we expect a version that is compatible? We will not make the jump to the new environment without this product as we use it so extensivly and the change would not be viable.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    SQL Compare already works with databases that were upgraded to SQL 2005. The queries that it performs against the system tables have been rewritten to use Microsoft's new SQL 2005 system table schema.

    The minute that you start expoliting the new features of SQL 2005, SQL Compare begins to fail. For instance creating an assembly in the database is not supported yet.

    These improvements will be made later, after the official release of SQL 2005.
  • Options
    MartinHMartinH Posts: 82 Bronze 2

    Thanks, sound like we can make the jump soon :-)

    We currently don't need the new features.

This discussion has been closed.