Solved

Upgared sql server 2012 or 2014?

Posted on 2014-09-23
3
322 Views
Last Modified: 2014-09-30
we are plaining to upgarate microsoft sql server 2008 to sql server 2014
we have sharepoint 2010 and MS excel 2010.

I just wondering any one give me any issue if we upgrate to sql server 2014 or 2012.


need main purpose is creating ware house and complete BI solution
0
Comment
Question by:ukerandi
[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 65

Expert Comment

by:Jim Horn
ID: 40339119
Nothing specific that I'm aware of, but since IT departments rarely get an opportunity to upgrade I'd go with SQL 2014, unless a case can be made that it's not able to handle whatever you need it for.
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40339284
our main focus is Building Dataware House and Complete BI solution with sql server 2012 or 2014.
We have sharepoint 2010 and Microsoft office 2010

Just wondering its possible to any clash or how easy to use sql server 2012 or 2014.

specialy we have to use Power piviot for excel 2010

Any comments i'd highly appriciate
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40339304
>Building Dataware House
It's called a data warehouse, not a dataware house.  
Whatever English translation app you are using is failing on this one.

You'll need to provide specific questions, as generalized terms like 'Complete BI solution' and 'how easy to use sql server 2012 or 2014' are too broad of a question, and many experts will not provide a detailed solution unless they are certain that it completely answers the question.

>specialy we have to use Power piviot for excel 2010
Office 2013 has a larger product offering of the Power BI suite then just the 2010 Power Pivot / Power Query.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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

730 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