What has changed for Visual Studio Team Edition for Database Professionals (aka VSDB, DB Dude) in the 2008 edition?
Installation: No more additional setup. In Visual Studio Team System 2008 VSDB completely integrated in the standard setup, so no more additional downloads. All you have to do is to make sure the Team Database Edition option is checked in the features to install window. The database project functionality is only available in two of the Visual Studio Team System SKU's:
Visual Studio Team System 2008 Database Edition.
Visual Studio Team System 2008 Team Suite.
The Visual Studio Team System...
I built a big DB Dude project from MSBuild command line and got a timeout error. MSBUILD : Build error TSD158: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The default timeout for query execution is 60 seconds and stored in the registry. We can extend the query timeout by changing these values. The registry entries are: HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\DBPro\Database\QueryTimeoutSeconds HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\DBPro\Database\LongRunningQueryTimeoutSeconds
Power Tools that extend the functionality of Visual Studio Team Edition for Data Professionals is now available. The tool includes: Dependency Viewer More refactoring support Extended Data Generation New MSBuild Tasks T-SQL Static Code Analysis Schema Manager API Read Gert's post for a more detailed explanation. Download the tool from here.
The Data DUDE team announced that Visual Studio Team Edition for Database Professionals Service Release 1 is ready for consumption! To summarize the knowledgebase article, the following features have been added: Cross-database references: You can reference objects within different databases by using database project references or by referencing a database metafile (.dbmeta). Improved SQL Server file groups support: You can define files within file groups as database project properties instead of having to create files and file groups within the pre-deployment storage script. Variables: Variables can now be defined in the database properties and...
Yesterday I gave a session about Team System For Database Professionals in the Are you Ready 2008 event. The audience had good time and went away with valuable knowledge about Team System For Database Professionals . You can find the slide decks from the session here. If you have any feedback about the lecture, I'd like to hear it! Enjoy!
Why output script from VSTS for Database pro failed to execute in Management Studio? Database pro output scripts are valid t-sql syntax, but remember: Database pro uses SQLCMD to deploy databases. How can you make it run? In Management Studio you need to swap into SQLCMD mode. Tthrough the Query -> SQLCMD Mode menu. Click the red exclaimation icon in your toolbar.
When you create your DB Dude project and try to build and deploy the project to the client's sandbox at the first time, you suddenly get the error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."
This error occurred because the networking protocols are disabled by default in SQL Server Express. In order to solve this problem you should configure SQL Server Express to accept remote connections. I followed this post's (at SQL...
A lot of users feel confused about the installation requirements of VSTS for DB Professionals (DB Pro).
"Team Suite or other product must be installed before Db Pro" as the ReadMe file says.
The requirements of VSTS for Database Professionals are:
Visual Studio Professional Edition/Visual Studio Team Suite. Team Edition for Database Professionals is available as a separate product; however, to evaluate the Team Edition for Database Professionals Trial you must first install the Visual Studio 2005 Team Suite 180-Day Trial.
The Visual Basic or C# language feature must be installed.
MSXML must be installed.
Visual Studio Professional Edition is included...