This is just one of those times when I have to wonder who’s calling the shots from a product perspective over at MS. I just started experimenting with Visual Studio Team System for Database Professionals and have run into an absolute show stopper that completely prevents me from being able to do anything useful with the product.
First off, I mentioned a while back the fact that “regular” DB projects in VS2005 were cripppled. I have no clue why Microsoft, who often goes so far out of their way to provide backwards compatibility, would have gone and trashed DB projects the way they did. It became somewhat clear when VSTS4DBP was announced that they were trying to actually create a “real” product around database development and I was happy because I figured this new support would include all the features that I lost and more. Well, as it turns out, with all the cool, new things that VSTS4DBP offers, they STILL don’t support DML/BCP in the product.
So, what does this mean exactly? It means that you’re basically left hanging, looking for your own home-brewed solution, for any “static” data you may have in your databases. Most likely that means executing bcp on the command line to export data from your tables, adding those files to your project manually and then adding some BULK INSERT statements into the Script.PostDeployment.sql file of the project.
Scary thing is, this was brought up and Microsoft has said that they consider it great feedback… for the next version of the product. Ridiculous, right? Please voice your opinions via this bug over on Microsoft Connect.