• hedera (12/31/2009)


    Thanks for the quick response, and I did consider going to SQL Server Express 2008 - my only reason not to would be that my production system is on SQL Server 2005 and I wanted the test system to be as close as possible. On the other hand, I ran my test system on 2005 for several months while the production systeme was on SQL Server 2000. Would you expect there to be any issues restoring a database on SQL Server Express 2008 that was backed up from SQL Server 2005? If that should be OK I may just go with the upgrade.

    I don't think there will be any problems but as with most things in implementation run some tests before production. I am assuming your database is not in compatibility 80 if it is then you may want to move to at least 90 for 2005 before going 100 which is for 2008.

    Kind regards,
    Gift Peddie