Solved

Upgared sql server 2012 or 2014?

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

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

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

809 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