• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

SQL - Workgroup / Standard Upgrade question

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
samntlam
Asked:
samntlam
  • 3
  • 3
1 Solution
 
TAB8Commented:
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
 
samntlamAuthor Commented:
Tab8:
what happen to the "in-place" upgrade? after uninstalled sqlexpress?
Sam
0
 
samntlamAuthor Commented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TAB8Commented:
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
 
samntlamAuthor Commented:
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
 
TAB8Commented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now