Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Creating a Solution

SQL Server 2005

In SQL Server Management Studio and Business Intelligence Development Studio, a solution is a container that groups and manages the projects you use when you develop end-to-end business solutions. A solution lets you handle multiple projects as one unit and to bring together one or more related projects that contribute to a business solution. For more information, see Solutions as Containers.

Solutions in SQL Server Management Studio and Business Intelligence Development Studio can include different types of projects. If you want to create an Integration Services package using SSIS Designer, you work in an Integration Services project in a solution provided by Business Intelligence Development Studio. For more information, see Introducing Business Intelligence Development Studio.

When you create a new solution, Business Intelligence Development Studio adds a Solution folder to Solution Explorer and creates files that have the extensions .sln and .suo.

  • The *.sln file contains information about solution configuration and lists the projects in the solution.
  • The *.suo file contains information about your preferences for working with the solution

A solution is automatically created when you create a new project in Business Intelligence Development Studio, but you can also create a blank solution and then add projects later.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.