Solved

SQL - Workgroup / Standard Upgrade question

Posted on 2008-06-24
6
443 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
  • 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now