Solved

Can I install SQL 2012 Express on SBS 2011 w SP1

Posted on 2014-03-18
3
851 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
  • 2
3 Comments
 
LVL 39

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 39

Accepted Solution

by:
lcohan earned 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

760 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

22 Experts available now in Live!

Get 1:1 Help Now