Microsoft BI Configuration Issue


When designing a BI projects in MSSQL Server 2012, it is noticeable to me that SQL Management Studio (SSMS) and Visual Studio are non-aligned, that is, a project developed in SSMS cannot be opened in Visual Studio and vise-versa. I am aware to solve this problem when in Visual Studio, I have to use a Solution Folder.

As Microsoft BI developer how are you able to deal with this configuration glitch? Will Microsoft address this technical issue in its MSSQL Server 2014 release?

Anonymous avatar x30
Guest
As seen in
Logosasseenin

2 Answers

Anonymous avatar x30
Arturo DiazReal User

The issue is not SQL Server, it is Visual studio. Visual studio works with solutions, that have in place projects. Everything in visual studio works this way, and that is the reason that we need a solution to work with the BI project. MSSQL on the other side does not need solutions. That is why a project can be opened directly in MSSQL.

We don’t consider this a glitch. VS is IDE tool oriented more for application development projects and it includes functionality to access another type of projects, but it is a natural form of work to integrate this on solutions. We always use a solution and we think this kind of approach gives order to the work, especially on collaboration teams.

Like (0)27 February 14
Tim little li?1414330104
Tim LittleConsultant

Hi, without knowing the full details perhaps this article will lead you in the right direction

http://msdn.microsoft.com/en-us/library/hh864423(v=vs.103).aspx

The .dacpac file is, in any case, the main item here.

Like (0)27 February 14
As seen in
Logosasseenin

Sign Up with Email