Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm in need of some help with SQL Server. I’m fairly new to SQL Server so bear with me.

My situation:

We currently have SQL Server 2008 Express installed and running on Windows Server 2003. We are reaching the max size for SQL Server 2008 Express, so we purchased SQL Server Workgroup 2008 volume license version. Now because the volume license product key is built in, I can’t do a standalone upgrade from the SQL Server 2008 Express version.

How do I go about installing the new workgroup version? Do I uninstall the express version and install the workgroup version? Do I install the workgroup side by side of the express? How do I transfer the data over from the express version to the workgroup?

As you can see, I need help on how to tackle this project. Please! Any help would be well appreciated

share|improve this question
add comment

2 Answers

Install a workgroup instance. Install any service packs / cumulative updates so that its @@version is >= the express instance. Backup the database from Express, restore it on the new Workgroup instance, take the database offline in Express, and point your application(s) at the new instance name (you'll need to update their connection strings).

I believe there are ways to do /SKUUPGRADE in these cases, but I'm not sure about Express -> VL, and I simply wouldn't trust an in-place upgrade anyway.

share|improve this answer
add comment

You can use the copy database wizard to move databases from one database instance to another.

Right-click on an existing database, choose TASKS and then at very bottom, is 'Copy Database'.

I would recommend the detach / re-attach database option, I don't like the other method, it's not reliable enough.

You'll probably want to test a couple of database detach / attach operations.

Detach takes the database offline, and makes it portable so you can change the volume, before re-attaching the database in a new location.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.