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