Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1202
  • Last Modified:

Can I install SQL 2012 Express on SBS 2011 w SP1

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
meyco
Asked:
meyco
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
" 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
 
meycoAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
"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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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