VSTS 2008 Database Edition GDR: Still More First Impressions

June 11, 2008 at 4:43 pm (Tools, Visual Studio) (, , )

Following on to my adventures in creating multi-environment deployment processes with the new version of Data Dude (DBPro, VSTS Database Edition, whatever we’re calling it this week).

I’ve create a new configuration, copying all the settings from the Debug configuration. I’m adding a new Deployment configuration file and making a change. The deploy worked. Woo hoo! Now to get really funky. I’ll create a new “Sql command variables file:” and add a variable for setting the data directory. Now to deploy and… Urk! Failed. It’s not recognizing my variable.

Now I’m stuck. I’ve checked the syntax. It’s right. I double checked it all and reran deploy. Now it works… Color me confused. Whatever. Successful test. Time to create another configuration, simulating a QA server… Got that working too. I don’t know what went south yesterday, but it’s all working now. Now to quantify it all and begin to create some standards.

I’m also going to check this all into source control to see how the connection information is stored. In 2005/2008 (not GDR), the connection info was stored in the .user file. We finally started checking our .user files in with the rest of the project, to the abject horror of every MS developer that heard about it. More on this tomorrow.

Permalink Leave a Comment

VSTS 2008 Database Edition GDR: More First Impressions

June 11, 2008 at 2:38 pm (Tools, Visual Studio) (, )

Because I was having so many problems yesterday after I tried doing everything at once, creating multiple deployments to multiple servers with a variety of different settings… Anyway, it didn’t work. So today I went back to square one. I created a blank project.  Yesterday I used the schema compare to capture the database, but today I right clicked on the project and found “Import Database Objects and Settings…” which did it all for me. Yee Ha!

Anyway, after getting all the objects in, I started trying to deploy. This time I got errors on FK’s. It somehow changed the order on the compound keys columns. While editing, I found that if I messed up the syntax and then saved the file, I didn’t get an instantaneous error. That bummed me out. I got used to that in the original Visual Studio. Anyway, I fixed all the FK errors and now I got the deploy to work. I’m now going to walk through creating custom configurations one step a time to see where the deployment stops working.

Permalink Leave a Comment

Auditing in SQL Server 2000/2005

June 11, 2008 at 8:26 am (Misc, SQL Server 2005) (, , , , )

TJ Belt wrote a nice article over at SQL Server Central on how to do Sarbanes/Oxley compliant auditing using SQL Server 2000 and/or 2005. it’s worth a read.

Permalink Leave a Comment

SNESSUG Speaker

June 11, 2008 at 7:20 am (PASS, SNESSUG) (, , )

Tonight we have Rob Walters of Microsoft speaking on Visual Studio 2008 Reporting Services. This should be a good one. Rob also recently published a book, Accelerated SQL Server 2008. I’m going to a party at the MS building in Waltham next week to celebrate the release of Rob’s book. Hopefully that means I can finagle a copy too.

Permalink Leave a Comment