Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Upgared sql server 2012 or 2014?

Posted on 2014-09-23
3
Medium Priority
?
350 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 66

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 66

Accepted Solution

by:
Jim Horn earned 1000 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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 part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

705 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