VSTS 2008 Database Edition GDR CTP 16

September 12, 2008 at 3:13 pm (SQL Server 2008, Tools, Visual Studio) (, , , )


CTP 15 utterly hosed the virtual device I had it on. I tried uninstalling, but it just wouldn’t come off clean. I finally have rebuilt the virtual and reinstalled everything except VSTSDB GDR. Having learned my lesson (the hard way as usual), I started a differential on my virtual for the install of CTP 16 so that I can roll back and install the release candidate and the release as they come out without having to go through that whole rebuild thing again.

While Gert & crew are still making some changes, the fundamentals are still there so my presentation at PASS should work fine as currently defined. The only problem I ran into was that I couldn’t get the database to deploy by simply clicking on the deploy menu choice. It built the scripts for the deployment but it wouldn’t run them on the server specified. I tested the script. It worked great.

Some experimentation showed the problem. Even though the configuration I was on had the deployment event set to “Build Deployment Script and Deploy Database” it somehow hadn’t registered and it was only building the script. I simply clicked on the right drop down choice, tried again and everything went through, no issues.

So next, I tried running from a command line. It worked flawlessly. I can now deploy and only pass the configuration that I want and I’ll get everything built into the database. Unfortunately, when I was running the command line builds, it was opening a new instance of Visual Studio each time I ran it… I’ll do more research on Monday.

If you’re interested in VSTSDB, I’m presenting at the PASS Summit this year on that topic. Please swing by.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: