SQL Server 2008 Express Upgrade


Author
Message
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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

Jeff Pagley
Jeff Pagley
StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)StrataFrame User (465 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
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

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search