Solved

Can I install SQL 2012 Express on SBS 2011 w SP1

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

910 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

23 Experts available now in Live!

Get 1:1 Help Now