I am looking to upgrade from SQL Server 2005 Express to 2008 Express.  Are there any issues or changes I need to be aware of?  How will this affect the way SF connects to the database for my current applications? How will this effect the way I develop with SF?

Thanks,

Jeff

Hi Jeff,



From SF point, I don't think there is any change you need to be aware off, SF will just connect to whatever server you choose. I believe what you have to take into consideration is if you are using any database functionality of 2008 version which does not exist in 2005 then previous user may have some problems.



When I did this upgrade in my dev environment, I simply detach the database from 2005 and attach it to 2008 and change the connection in SF for the new SQL instance.

Edhy Rijo

Hi Jeff,



Edhy is correct in that it is very easy and straight forward. Since you are moving forward instead of backwards, there should be no compatibility issues with your database. If you are using the DDT, you can use the same PKG to deploy to SQL Server 2008. If you want to move an existing database over, you can either back it up and restore or just detach it and re-attach it like Edhy suggested.