Visual Studio Team System 2008 Database Edition

יום רביעי, נובמבר 28, 2007

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...
תגיות:
אין תגובות

DEV215: Presentation and Demo Download

I uploaded my presentation and demo, done in DevAcademy2. Now you can download, use and review it. Presentation - DEV215 Integrating Databases Into ALM Demo -  DEV215 Integrating Databases Into ALM
תגיות:
אין תגובות

Data Dude: Synchronize vs Refresh

יום ראשון, אוקטובר 28, 2007

What is the difference between the "Refresh" button in "Solution Explorer" and the "Synchronize" button in "Schema View? I posted an explanation about it. Read it here.
תגיות:
אין תגובות

SqlBuildTask timeout

יום שבת, ספטמבר 8, 2007

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
תגיות: ,
אין תגובות

DBPro PowerTools Now Available!

יום ראשון, אוגוסט 12, 2007

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.
תגיות: , ,
אין תגובות

Team Edition for Database Professionals SR1

יום שלישי, יולי 24, 2007

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...
תגיות: ,
אין תגובות

Are you Ready 2008 DB Dude presentation

יום שלישי, יולי 3, 2007

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!
תגיות: ,
אין תגובות

How to run scripts from VSTS for DB Pro in Management studio?

יום ראשון, יוני 24, 2007

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.
תגיות: ,
אין תגובות

SQL Server does not Allow Remote Connections Error

יום שני, מאי 21, 2007

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...
אין תגובות

VSTS for database professionals installation requirements

יום שישי, מאי 18, 2007

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...
תגיות: ,
אין תגובות