How do you upgrade your SQL Express database to workgroup or standard SQL Server?
I have a website that was originally developed using a SQL Express database in the App_Data folder. Now I need to update it without losing any data in SQL Server 2005 Workgroup or Standard.
Is there a guide to properly update Microsoft or another source?
0
Brian Boatright
source
to share
1 answer
When you install Workgroup or Standard, it simultaneously upgrades the database server and database. Make sure you have a backup of your database (just in case). You can always back up the database and restore it to Workgroup or Standard.
Here's the guide: http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=55
+3
GluedHands
source
to share