April 12, 2004 at 10:38 am
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
April 13, 2004 at 2:53 am
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
April 14, 2004 at 12:17 pm
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