VSTSDBE GDR RC0: No Joy in Mudville

November 14, 2008 at 10:32 am (PASS, Tools, Visual Studio) (, , )

A few posts ago I outlined the problems I was having getting the RC0 of the GDR to deploy appropriately. I was successful in a deployment, so I thought I was done. Yesterday I went to do a run through of the presentation for PASS and my deploy failed. Despite the fact that I’m running on the same machine with the same project that worked before. I’ve now gone back through the whole process again, but I’m getting nothing but failures. It’s totally hosed. At this point, barring a miracle, I’m going to present the process and then explain that I can’t demo it because of failures.

I don’t know if it’s just a configuration issue with my virtual machine or something flawed in the release. Either way, I’m at a standstill and completely bummed. I’m going to try recreating things, but I suspect that I’m going to have to assume a failure at the conference and not run the demo.

I posted the issue and the error messages I’m getting over at the MSDN Forum for VSTSDBE

Permalink 3 Comments

VSTSDBE RC0 Post 2

November 3, 2008 at 4:01 pm (nHibernate, Tools) (, , )

There is no joy in Mudville.

The install of RC0 went smoothly. I was able to create a new server project and deploy it. I was able to reverse engineer AdventureWorks into a new project and deploy that. When I went to create a new compound project, combining the output from the two… deployment failed. I got an arcane error about something in the Microsoft.Data.Schema.SchemaModel.ModelSerializationException erroring out. Useful. So, at this point, the functionality I had in my demo for the PASS Summit isn’t working. Yikes. I’ve got two weeks… no pressure…

I posted a note about it over at the MSDN discussion site. If you have a solution, swing by and drop it off.

Permalink Leave a Comment

VSTSDBE RC0 Install

October 31, 2008 at 11:08 am (Tools, Visual Studio) (, , )

I’ve downloaded and started the install. The first screen I’m seeing is not filling me with confidence. The executable that is currently running is called “DBProRepair.exe” However, the installed completed without any issues.

Just for giggles, I tried opening my PASS presentation (created on CTP 17). If it worked, I wouldn’t have to recode. Ah, well, no joy. Not that I expected any. Oh, but the Conversion Report that comes up afterwards is very informative.

Reverse engineer against the AdventureWorks2008 database went off without a hitch. All the objects imported into the database with no issues too. So far, so good. Created all the projects. No issues. I’m configuring for a deployment now. We’ll see how that goes. Builds worked fine. I forgot to change the deploy action the first time I did a deployment. Second time… Frell!

The compound deployment is failing. I had something configured wrong… I’ll post when I get it figured out.

Permalink Leave a Comment

Visual Studio Team System Database Edition GDR RC

October 31, 2008 at 7:31 am (Tools, Visual Studio) (, , , )

I’m a bit late to notice this, but Gert Drapers announced on Monday that the release candidate for VSTSDBE, or good ole VSDB as I’ve decided to call it, is now available. I figured they’d do something during the Professional Developers Conference (where supposedly a new printing of my book was being given out). Now I need to get on the stick & upgrade my virtual… maybe. According to the post, functionality hasn’t changed. Maybe I should just leave everything alone on my machine until after PASS… Nah!

I’ll post progress for the uninstall, the install and the recreation of the compound project.

Permalink Leave a Comment

VSTS Database Edition GDR CTP 16 II

September 15, 2008 at 3:35 pm (Tools, Visual Studio) (, , )

I just finished setting up a new automated build process including TFS! I’m loving this new version. There’s so much more for me to learn and I’ve got to get it all in before PASS in November.

I was reading how they’ve changed the differential mechanism. It sounds like a huge improvement. Time for more testing.

Permalink Leave a Comment

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.

Permalink Leave a Comment

PASS Summit

September 10, 2008 at 9:12 am (PASS, SQL Server 2008, Tools, Visual Studio) (, , , , )

It looks like this year is going to be pretty good. They’ve expanded the program. If you’re not going, you should consider it.

Personally, I’m pretty excited. I’m presenting our build and deployment process using Visual Studio Team System Database Edition. I’ve got the first half of the presentation down cold because it’s how we’ve been doing our deployments for a couple of years now. The second half concerns me a bit. I’m showing the new release that works with SQL Server 2008. Unfortunately that new release isn’t done and I keep having to update my code and slides as the new versions come out with different functionality. I’m more than a little bit nervous about that part of the presentation. I wish there was a way to bounce it off Gert Drapers before I gave it. Maybe I’ll fire off an email to him after they finish coding. I’d do it sooner, but I’m not about to distract the man that’s making a tool I use so much.

Speaking of which, the new version, CTP 16, has a great addition. There’s an executable, I assume distributable without license, that allows for installs of VSTSDB projects without having a full Visual Studio install. This tool is going revolutionize, again, database development and deployment. You have to love it!

Permalink Leave a Comment

« Previous page