SQL Server database difference tool

Creating Multidimensional Models Using SQL Server Data Tools (SSDT)
April 22, 2018 – 09:52 am
SQL SERVER - How to Compare the Schema of Two Databases with

This documentation is archived and is not being maintained.

SQL Server 2012

Microsoft SQL Server provides two different environments for building, deploying, and managing Analysis Services solutions: SQL Server Data Tools (SSDT) and SQL Server Management Studio. Both of these environments implement a project system. For more information about Visual Studio projects, see Projects as Containers in the MSDN Library.

  • SQL Server Data Tools (SSDT) is a development environment, based on Microsoft Visual Studio 2010, used for creating and modifying business intelligence solutions. With SQL Server Data Tools (SSDT), you create Analysis Services projects that contain definitions of Analysis Services objects (cubes, dimensions, and so on), which are stored in XML files that contain Analysis Services Scripting Language (ASSL) elements. These projects are contained in solutions that can also contain projects from other SQL Server components, including SQL Server Integration Services and SQL Server Reporting Services. In SQL Server Data Tools (SSDT), you can develop Analysis Services projects as part of a solution that is independent of any particular Analysis Services instance. You can deploy the objects to an instance on a test server for testing during development, and then use the same Analysis Services project to deploy your objects to instances on one or more staging or production servers. The projects and items in a solution that includes Analysis Services, Integration Services, and Reporting Services can be integrated with source code control, such as Microsoft Visual SourceSafe. For more information about creating an Analysis Services project in SQL Server Data Tools (SSDT) using Analysis Services, see . You can also use SQL Server Data Tools (SSDT) to connect directly to an existing Analysis Services instance to create and modify Analysis Services objects, without working with a project and without storing object definitions in XML files. For more information, see, and .
  • SQL Server Management Studio is a management and administration environment, used primarily to administer instances of Analysis Services, SQL Server, Integration Services, and Reporting Services. With SQL Server Management Studio, you can manage Analysis Services objects (perform back-ups, processing, and so on), and you can also create new objects directly on an existing Analysis Services instance by using XMLA scripts. SQL Server Management Studio provides an Analysis Server Scripts project in which you can develop and save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). Usually, Analysis Server Scripts projects are used for performing management tasks or re-creating objects, such as databases and cubes, on Analysis Services instances. Such projects can be saved as part of a solution and integrated with source code control. For more information about creating an Analysis Server Scripts project in SQL Server Management Studio using Analysis Services, see .
Source: technet.microsoft.com
Related Posts