Business Intelligence Development Studio (BIDS)
Microsoft introduced Business Intelligence Development Studio (BIDS) in SQL Server 2005. BIDS is a SQL Server management tool built to help developers who are using SQL Server Integration Services, Reporting Services and Analysis Services. BIDS is nothing but Microsoft Visual Studio along with project templates specific to SQL Server Business Intelligence.
Microsoft introduced Business Intelligence Development Studio (BIDS) in SQL Server 2005. BIDS is a SQL Server management tool built to help developers who are using SQL Server Integration Services, Reporting Services and Analysis Services. BIDS is nothing but Microsoft Visual Studio along with project templates specific to SQL Server Business Intelligence.
SQL Server Data Tools (SSDT)
(SSDT) is a replacement for SQL Server BIDS, starting from the release of SQL Server 2012. This SQL Server management tool has all the features of BIDS and has certain new enhancements such as:
(SSDT) is a replacement for SQL Server BIDS, starting from the release of SQL Server 2012. This SQL Server management tool has all the features of BIDS and has certain new enhancements such as:
- The Data Compare feature, which allows you to compare and synchronize data between two databases.
- Support for SQL Server Unit Testing, which allows one to generate unit tests for SQL Server functions, triggers and stored procedures.
- Object Explorer, which can create, edit, delete, can rename tables, functions, triggers and stored procedures and can even perform certain level of database administration tasks.
No comments:
Post a Comment