Uploaded October 2012 | Updated September 2026, 2 weeks ago
Subscribe to our channel here for notifications on new video trainings. For more videos on technology, visit our website at http://www.techytube.com.
By jayanth.kurup@techytube, for more from this author visit:
techytube.com/author/jayanth.kurup
Most database professionals know this a BIDS from previous versions of SQL Server. However there is a key distinction here. Previously database design was handled within Visual Studio so if you wanted to create a database you would use Visual studio and if you wanted to create a SSIS package you would open BIDS. With SSDT the entire set of project related to the database has now been integrated into one set. This means you can now create the MS SQL Server database in the same interface as the packages. As a result the schema compare feature is also available by default after installing SQL and there is no need for an additional VS interface.
Subscribe to our channel here for notifications on new video trainings. For more videos on technology, visit our website at http://www.techytube.com.
By jayanth.kurup@techytube, for more from this author visit:
techytube.com/author/jayanth.kurup
Most database professionals know this a BIDS from previous versions of SQL Server. However there is a key distinction here. Previously database design was handled within Visual Studio so if you wanted to create a database you would use Visual studio and if you wanted to create a SSIS package you would open BIDS. With SSDT the entire set of project related to the database has now been integrated into one set. This means you can now create the MS SQL Server database in the same interface as the packages. As a result the schema compare feature is also available by default after installing SQL and there is no need for an additional VS interface.
