different sql server versions for development and production

  • Hi,

    Is it possible to develop a database in SQL server 2000, backit up and restore it on a different sql server version like 7.

    Thanks in advance

     

  • Hi,

     

    I have had to do something similar and the way I managed it was to scrip all changes/developments on the 2000 database – you can check the ‘Only script 7.0 compatible features’ on the formatting tab and then applying them to the 7.0 database.  With regard to compatibility remember to use temporary tables rather than table variables and that UDFs are not supported in version 7.0

     

    I know you can attach 7.0 MDB and LDF files to a 2000 database and it will upgrade them to 2000 as it attaches them.  Whether you can run the 2000 database in 70 compatibility mode detach and copy the MDB and LDF files and then attach them to the 7.0 database I don’t know – it’s not something I’ve ever tried and sounds like a recipe disaster should your 7.0 database be on a production server!  Perhaps more knowledgeable people than me will have a better idea but I would stick to scripting changes and developments and testing them as thoroughly as possible before applying them to the 7.0 database.

     

    Hope this helps,

     

    Andrew McKeon

  • I wonder if you save ( i don't have sql 2k around) 2K datafile in EM as 7.0 compatible ( as oppose to 8.0 for SQL 2000) will it work then?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply