Solved

Can I install SQL 2012 Express on SBS 2011 w SP1

Posted on 2014-03-18
3
911 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Improvement  ( Speed) 14 28
Return 0 on SQL count 24 30
optimize stored procedure 6 28
New to SSRS, extremely slow running report. 8 20
Know what services you can and cannot, should and should not combine on your server.
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

803 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