Solved

Upgared sql server 2012 or 2014?

Posted on 2014-09-23
3
305 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

760 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

22 Experts available now in Live!

Get 1:1 Help Now