VSTS 2008 Database Edition GDR CTP 16

Home / SQL Server 2008 / VSTS 2008 Database Edition GDR CTP 16

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.

OK, fine, but what do you think?