?
Solved

SQL - Workgroup / Standard Upgrade question

Posted on 2008-06-24
6
Medium Priority
?
450 Views
Last Modified: 2010-05-18
i read this through ee/kb
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22853240.html
reading "zcrammond" (wrote) comment.

my questions:
in the subject - comments,
which version was it? (sql workgroup or sql standard) i am confused!

if buy sql2005 workgroup (5-cal) do i uninstall SQL Management Studio Express still?
or was that the sql standard version that was discussed in that regarding to uninstall management studio express?

-------

I know for sure we will be working on the in-place upgrade (without changes name instance) the concern is, which version require to uninstall management studio express?

thank you!
Sam
0
Comment
Question by:samntlam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 10

Expert Comment

by:TAB8
ID: 21862734
Standard and workgroup have teh full version of Management stuido ..  so yes if you have the sql express ms version .. backup your databses and uninstall sqlexpress..  install SQL Standard or workgroup and restore your DB's
0
 

Author Comment

by:samntlam
ID: 21862796
Tab8:
what happen to the "in-place" upgrade? after uninstalled sqlexpress?
Sam
0
 

Author Comment

by:samntlam
ID: 21862827
And, backup database from same folder / directory & restore them to the same folder / directory after upgraded to SQL Workgroup - Standard!... does this sound right? and
Will this represent conflict - double work since these database were already in it resided folder / directory?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 10

Expert Comment

by:TAB8
ID: 21869635
the inplace upgrade will refer to upgradin versions on the same server .. not side by side ie 2 differrent servers ....   as for  (backup database from same folder / directory & restore them to the same folder / directory after upgraded to SQL Workgroup - Standard) No you dont need to worry about this ...  Just make sure you take a full backup of all the databses... if it was my upgrade I would do the following
1, backup all databses
2, Script all user accounts and permissions (heap of these on teh web)
3, script any agent jobs
4, uninstalll SQL express (as thsi will be the default sql instance)
5 install your standard edition
6, restore you db's
7, run scripts to create users

all done  :)
0
 

Author Comment

by:samntlam
ID: 21869780
Wow! sound so easy...
does that also apply to workgroup edition?
just in case we decided to buy workgroup instead of standard and do you know what's the differences between them? (workgroup - standard)

----
if i didn't mention before, our production works 7 days a week and rely on the database to get all the work done.

since everybody will be log off and stop all operations during the in-place upgrade
my hesitation - worrying would be....
how much of time spend on the steps - process that you just described?

I am sure restarting the server is a MUST! in that situation (uninstalling - installing i.e)
I have not include - thinking of any possible WSUS for SQL before and after...

Sam
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 2000 total points
ID: 21871787
You will need some downtime ...
you will also need to apply Service Packs etc ....

Workgroup and Standard are pretty much the same (same to install) the feature differance between the two can be found on the Microsoft website

I would go standard ..  as in the past when I have priced the two options they work out the same as you couldnt get workgroup without software assurance ...
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question