Visual Studio team edition for Database Connector sionals [translation]

You can call it datadube, teamdata, vstsdbp, or anything else. This new Visual Studio tool specifies the correct direction for the database development phase of the project under your control. Of course, I know that your database development is under control, and your developer has created all required database objects: tables, indexes, user-defined functions, stored procedures, and so on, it runs well and you do not need any other tools. These are my ideas before I start using this new Visual Studio tool. The first thing you understand about this new tool is that you will dramatically change your views on database development and database development cycles.

Before that, I used SQL Enterprise Manager, query analyzer, and SQL management Studio (SQL 2005) for most database development tasks. I used these tools to create databases and tables on a local SQL Server database instance, indexes, user-defined functions, stored procedures, and so on. All of this work is "point-to-point", not benefiting from code control, unit testing, or any strict setup of stored procedures. If I forget to back up the database and modify a table name, this will lead to many functions and disconnections, which takes a lot of time to find and fix. This is not a professional method for developing databases for important programs, but it is the best tool we can do.

Now, with Visual Studio team edition for database professionals, this will not happen again. In the development cycle, database development has all-round support. Currently, all database development can be developed offline in a separate environment (this requires your database server to be established and run ), all user-defined functions and stored procedures can use the typical data generated by this tool for comprehensive unit testing. In addition, the biggest benefit of this tool is that it fully integrates the team Foundation server, so that your database structure (Database script) can be like any other C #, BizTalk, the code is controlled like the web program.

I really recommend that all database developers download the latest CTP version of The New Visual Studio tool when developing any database. This is really an extra highlight that may lead many of us to upgrade to Visual Studio team suite!

Original article: Visual Studio team edition for database schemsionals