?
Solved

Can I install SQL 2012 Express on SBS 2011 w SP1

Posted on 2014-03-18
3
Medium Priority
?
1,083 Views
Last Modified: 2014-03-22
I am trying to migrate a SQL database from a stand alone PC running W7 w SQL 2012 Express, to a New Small Business Server, SBS 2011 w SP1, that came with SQL 2008 R2 Express integrated with SBS.  No go.  I either need to upgrade the version of SQL Express on the Server, or convert the 2012 database to 2008 database.   SBS 2011 is not listed on the list of machines approved by Microsoft for SQL 2012.   I don't want to break my SBS installation.  Should I call Microsoft, or does someone have some experience with this.  

Can I install SQL 2012 Express on my SBS 2011 server, and/or is there a procedure (export/import), or an application utility to convert 2012 SQL database to 2008?
0
Comment
Question by:meyco
[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
  • 2
3 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39937765
" SBS 2011 is not listed on the list of machines approved by Microsoft for SQL 2012.  "

but the note says:

"SQL Server editions that are supported on Windows Server 2008 R2 Standard 64-bit are also supported on Windows Small Business Server 64-bit.'

And the SQL Express 2012 can be installed on "Windows Server 2008 R2 SP1 Standard 64-bit"
- just make sure to put SP1 on the OS.

http://msdn.microsoft.com/en-us/library/ms143506.aspx#top_sp

Also "is there a procedure (export/import), or an application utility to convert 2012 SQL database to 2008? " 

Only thing you can try is to script ALL database objects on 2012, with compatibility mode set to 2008, then create the database on 2008 server, then from the 2012 to export all data into your 2008 database.
0
 

Author Comment

by:meyco
ID: 39937864
Okay, Icohan, I see that note.  This is good news...I think.

I have spoken with the software developer and he says he can write a script or utility to convert my clients 2012 database to 2008.   My SBS Engineer says that is the way to go.  So my next questions are:  

Does anyone have any experience with installing 2012 Express on SBS 2011.  I have read that this can drag down server performance, but my engineer says we can disable the 2008 SQL processes to eliminate that problem.  

I am also concerned about breaking links between SBS integrated apps (SQL Server), and SBS management consoles; and/or the centralized Windows update service.  Will future Service packs for SBS 2011 address SQL 2012, or just look to update SQL 2008 issues, requiring me to install separate service packs for SQL 2012?  

What other issues might we be looking at if we do this?
0
 
LVL 40

Accepted Solution

by:
lcohan earned 1000 total points
ID: 39937890
"I have spoken with the software developer and he says he can write a script or utility to convert my clients 2012 database to 2008." SQL own Import/Export (based on SSIS) can do that easily.

On the performance note please see the answer below to a similar question and note that the issue with SQL running on SBS is mainly the memory contention no matter the version/edition for both SQL and SBS. That is - they don't work (unfortunately) very well together.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_27985341.html
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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 to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

771 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