?
Solved

SQL data tools from SQL server 2012 and SQL data tools - business Intelligence for VS 2012

Posted on 2014-03-31
14
Medium Priority
?
475 Views
Last Modified: 2016-02-10
Dear all,

When we are install the integration service from SQL server 2012 source CD, it will instlal the SQL data tools.

but we can download the SQL data tools - business INtelligence for VS2012 too, what is the difference between them?
0
Comment
Question by:marrowyung
[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
  • 9
  • 5
14 Comments
 
LVL 40
ID: 39966205
BI includes  Analysis Services, Integration Services, and Reporting Services projects. http://msdn.microsoft.com/en-us/library/ms173767(v=sql.105).aspx

Integration service is a thus a subset of the Business Intelligence package.

The data Tools run in the same environment, but you have more project templates in the BI.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39966279
so you mean this one "SQL data tools - business INtelligence for VS2012 " include the binary of Analysis Services, Integration Services, and Reporting Services.

so the  SQL data tools - business INtelligence for VS2012 will have all project of the 3 x component ?

but if we use the SQL installation source, we can select that ourselve and finally no diff?
0
 
LVL 40
ID: 39966655
I suppose so.

You say you are installing from the SQL Server 2012 CD, and I haven't done that for years, since everything I install now is downloaded. When downloaded, the components are usually downloaded separately to prevent a download that is too long. On the CD, it is quite possible that everything is included. If not, then it can be downloaded later.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 1

Author Comment

by:marrowyung
ID: 39968938
you can see that "SQL Server Data Tools - Business Intelligence for Visual Studio 2012" is just one file and when I run it, it shows:

SQL Server Data Tools - Business Intelligence for Visual Studio 2012
you can see that this is a tools that integrate the SQL tools to the VS2012, am I right?

so I think we are talking about diff. topic! I mean what is the SQL data tools from the SQL server 2012 CD for and what is the diff between the one SQL disc provide and this one.
0
 
LVL 40
ID: 39969093
As I told you before, I haven't installed such stuff from CD for years, getting them through downloads from Microsoft.

The CD probably provides you with everything, while on a download, the different components and tools are available separately in order to minimize the download time by enabling you not to download stuff that you won't use.

So there is no difference. They are simply different ways to get the same tools.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39969349
"As I told you before, I haven't installed such stuff from CD for years, getting them through downloads from Microsoft."

yeah, I can recall that

One thing, I think this tools exist for SQL server 2012 as we can't connect to SQL server 2012 SSIS server from SSMS, am I right? so they provide this tools since SQL 2012 as they keep saying they want to line up DBA and developer, agree?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39969355
but why we have SQL data tools (VS 2010 shell) and that "SQL data tools - business INtelligence for VS2012"?

that later on only design for VS2012?

can you find the x64 version of SQL data tools - business INtelligence for VS2012 ? I can only find 32 bits version.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39969369
I can't connect SSIS via SSMS, can you ? see attached.

when connecting SSIS from SSMS 2012
0
 
LVL 40
ID: 39969419
Have you read the error message carefully. You need to run as administrator.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39969602
yes I did,

The fact is it doesn't work.

you mean the account runs the SSIS, right?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39969622
I run the SQL server 2012 SSIS on Windows 8.1 PC, any known issue like that?
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 1500 total points
ID: 39972047
For the connection problem, try http://msdn.microsoft.com/en-us/library/hh213130(SQL.110).aspx

As for Windows 8.1, I cannot say. I searched around on the Microsoft site, but with version 2014 released yesterday, a lot of the links for 2012 bring you to 2014. I've been able to get a few pages stating Windows 8 as a supported system, but nothing with 8.1.

One thing that is almost sure, you need at least Windows 8.1 Pro for a lot of features, so if you are on a lower edition, it can lead to problems.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39972697
"As for Windows 8.1, I cannot say. I searched around on the Microsoft site, but with version 2014 released yesterday, a lot of the links for 2012 bring you to 2014. I've been able to get a few pages stating Windows 8 as a supported system, but nothing with 8.1."

I think there should not be a problem as SSIS by design is secured in this way!

what we have to do is to right click on that SSMS icon and run as administrator, then connect to SSIS.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 39972701
that one: http://msdn.microsoft.com/en-us/library/hh213130(SQL.110).aspx , is not going to work,  I tried last night!
0

Featured Post

TCP/IP Network Protocol Cheat Sheet

TCP/IP is a set of network protocols which is best known for connecting the machines that make up the Internet. The truth is that TCP/IP is one of the oldest network protocols and its survival is mainly based on its simplicity and universality.

Question has a verified solution.

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

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…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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

762 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