![]() The 'less than expected' adoption of data dude and VSTE in general, the every tightening integration of VS infrastructure into the SQL Server tools and the highly accelerated investment in SQL Azure all led to the decision to provide SSDT as a free tool for all SQL Server users with SQL Server 2012. Microsoft seized the opportunity to kill 3 birds with one stone here. SSDT is actually an evolution of data dude. Data Dude offered schema and object creation using database projects inside VS, off line 'virtualized' development without an actual SQL Server instance, unit testing, data generation capabilities, schema and data compare features, code review, smart debugging and of course the ability to deploy these projects along with the application while maintaining strict version control - a term most production DBAs only heard of theoretically. Data dude was built to help developers use their familiar and comfortable VS environments while allowing integration of the database development into the VS ALM (Application Lifecycle Management). Drapers that gave it its more common name, "Data Dude". A short and friendly name if you abbreviate it to VSTSEDBP. What a lot of DBAs didn't know, that since 2007, Visual Studio (in some versions) offered a complementary database development tool called "Visual Studio Team System Edition for Database Professionals". SSMS also included the visual schema designers (A separate blog topic.), Query designers, scripting features and many others that are used by both DBAs and developers. You can manage all your SQL Server instances using graphical tools, wizards and using T-SQL. SSMS actually serves 2 main purposes - Management and development. I have to agree that Microsoft did leave some space for confusion and a lot of duplicate functionality in both tools so let's try to clear up a bit of this confusion.īefore SQL Server 2012, the only management / development tool that shipped with SQL Server as part of the installation was SSMS. From the questions in the MSDN SQL Server forum which I moderate, I realized that the distinction between SQL Server Management Studio (SSMS) and SSDT is not clear enough to many. I've recently encountered some confusion regarding one of the new components of SQL Server 2012, the SQL Server Data Tools AKA SSDT.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |