Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » VSDB2008GDR   (RSS)

Pre and Post Deployment Events

Visual Studio makes it relatively easy to hook in to pre and post build events, by using the Project properties tab named Build Events. However when using Database Projects (.dbproj) you more often need to do something at deployment time. The good news Read More...
Posted Tuesday, October 13, 2009 2:33 PM by gertd | 1 Comments

Pre-Deployment Scripts

Pre-deployment script do not change the outcome of deployments! The above statements is something that most users do not realize when using pre-deployment scripts. Since the pre-deployment script is included in to the deployment script, it therefore by Read More...
Posted Monday, September 14, 2009 1:48 PM by gertd | 0 Comments
Filed under: , ,

NESQL Presentation – Declarative Database Development

Last week, September 10, I was invited by the New England SQL Server User Group to present about my favorite topic “ Declarative Database Development ”. I posted the slides of the presentation at DBProj.com . GertD @ www.DBProj.com Read More...
Posted Monday, September 14, 2009 11:57 AM by gertd | 0 Comments

MyDevConnections Volume 2 issue 1

The DevConnections conference organization (Tech Conferences Inc.), just released the latest issue of the magazine accompanying the conferences, named: MyDevConnections . In this edition (volume 2, issue 1) you will find an article that I wrote about Read More...
Posted Wednesday, September 09, 2009 8:26 PM by gertd | 0 Comments

SqlCmdVars.exe

This post announces the availability of a small helper utility that will allow you to maintain your database.sqlcmdvars files from a command line tool. Description: What is the scenario? If you are using vsdbcmd.exe to deploy your schema, you include Read More...
Posted Saturday, August 01, 2009 5:46 PM by gertd | 0 Comments

VSDB 2008 Version Numbers

We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual Read More...
Posted Wednesday, July 29, 2009 3:37 PM by gertd | 0 Comments

VSDBCMD.EXE Return Codes

Quick one based on a forum question where somebody asked how to detect if VSDBCMD.EXE failed or succeeded inside a batch file. VSDBCMD.EXE does not return a very elaborate amount of information, there are just two return values 0 and 1, where zero indicates Read More...
Posted Tuesday, July 21, 2009 1:09 PM by gertd | 1 Comments

Assigning MSBuild Properties to SQLCMD Variables

I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD variables. In order to make the Visual Studio 2008 Team System Database Edition GDR release use the data from an MSBuild property inside a SQLCMD variable you Read More...
Posted Sunday, June 21, 2009 4:21 PM by gertd | 1 Comments

DBSchema file for SQL LiteSpeed XP’s

Based on a customer request I created a .dbschema file which contains the definitions of all the extended stored procedures used by SQL LiteSpeed 5.0 that live inside the master database. Since schema import does not import the definition of extended Read More...
Posted Wednesday, June 10, 2009 5:10 PM by gertd | 2 Comments

Release Candidate of GDR QFE

Yesterday, March 25th, the development team released an RC of the upcoming QFE of the Visual Studio 2008 Team System Database Edition GDR bits. I was surprised to read the new naming “ Visual Studio 2008 Database Edition GDR v2 RC1 ”. Anyhow what is in Read More...
Posted Thursday, March 26, 2009 6:31 PM by gertd | 9 Comments
Filed under: ,

SQL Connections Slides and Demo Posted

It was great to be able to meet many new users of the Database Edition product at the SQL Connection Spring 2009 conference this week. Thank you for attending the sessions. There were lots of great questions, critical feedback and input for new features Read More...
Posted Thursday, March 26, 2009 1:55 PM by gertd | 3 Comments

DBPROJ vs. DBP

Can the “real” database project please indentify itself? Life can be confusing and we did not help you making it much easier by having two types of Database Projects inside Visual Studio. For the longest time there has been a “Database Project” inside Read More...
Posted Wednesday, March 25, 2009 8:52 AM by gertd | 4 Comments
Filed under: ,

Up to SQL Connections Spring 2009 (Orlando, FL)

Next week I will be presenting at SQL Connections in Orlando where I will be covering some fun topics on DataDude and general SQL Server. Here is the list. SQL Connections Spring 2009 (Orlando, FL) SDB413: Automating Database Deployment Do you have a Read More...
Posted Friday, March 20, 2009 11:46 AM by gertd | 1 Comments

FIX: Blank Unit Test Designer Problem

If you are running in to the following problem when creating unit tests when using database projects, there now is a fix! Consider the following scenario, you have you database project (.dbproj) open and requesting the creation of a Database Unit Test Read More...
Posted Wednesday, March 11, 2009 1:21 PM by gertd | 2 Comments

Dealing with Confused Installations

  Is your Visual Studio Team System 2008 Database Edition GDR installation confused? Does your menu suffer from multiple instance disorder? Here is what you can do about it. Make sure that Visual Studio (devenv.exe) is closed. Start an elevated command Read More...
Posted Sunday, March 08, 2009 4:43 PM by gertd | 5 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker