Disappointment: DiscountASP.NET doesn't support Visual Studio Database Project Deployment

Judge for yourself. I'm disappointed and frustrated they can't do something so simple to support such an amazing Microsoft technology. Visual Studio Database Projects are amazing, as is SQL Server 2008. So much for being a gold partner! This is a major issue for us; sufficient to force us to another hosting company with better support. In my opinion, this support engineer was more interested in closing the ticket than seeing if I had a valid request that might help other customers. He was polite, but unhelpful.

Does this cause you problems too? If so, please chime in!

 

No. I'm specifically using the technology that you can download here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en
This is an extension to Visual Studio that add's the concept of Database Projects.

I tried to deploy 2 ways:

• Using the Deploy context menu on the project
• Using the Schema Comparison feature

Both of these are necessary tools depending on the task at hand.


Thanks for looking at it.


Sean


Exoss


(408) 594-1084

 

Can you please give me just one example of actual security risk posed by allowing customers to select from read-only server-level dynamic management views? Otherwise, I'll be left feeling that this was just security rhetoric or unfounded paranoia.

I'm not asking for HTTP endpoint access. That is a false comparison.

 

Take a look at the Microsoft documentation link in the original post. It's very clear on what permissions are required for what operations. In fact, I even asked for just a single permission that ought to be the only one I'm missing given my login has db_owner rights on the database.

There's no need to guess at the rights.

Sean
Exoss

 

It's more than likely that you can be more granular with thepermissions than even the article says. All we need to do is identify the exact dmv's needed and determine whether those pose any security risk that you're concerned with. So one of the following may work:

• I can identify the *exact* permissions needed by emulating this situation in my development environment
• You can identify the *exact* permissions needed by actually testing this within your environment
• Contact Microsoft and ask them exactly what's needed and why

If we were able to get the appropriate information, would you folks be willing to make the security changes assuming they are reasonable?


Sean


Exoss

 

As I said at the beginning, this is a disappointment. It would have been much more effective for all of us if you just honestly said: "We're not going to budge no matter what the reason."We've wasted my time and all of yours.

 

The first sentence of the response in helpdesk was, "I am afraid we do not support this method of database deployment." You quoted it yourself. So I think suggesting that we have wasted your time is a bit specious. You came here to force the issue in public, so we dealt with it in public. Any time wasted on it is the result of your post.

We get requests to add or change something several times a day. We have to base additions or changes on demand and/or necessity. It does not make sense from a business or server and network management standpoint to commit resources to implementing things that only a tiny number of our customers will use or benefit from. I'm sure you understand.

There are certainly hosts that will add or change anything that you ask for. Just remember, hundreds of other users on the same server are doing the same thing. Seethe potential problems there? We have a couple of guys here in support who used to work fora host that did just that, and trust me, you would not want your site running on any of their servers.

Sorry we can't meet your needs in this case.

 

I am a new customer that just signed up for new hosting with a new database and I am not impressed with the quote from discountasp.net staff... "It does not make sense from a business or server and network management standpoint to commit resources to implementing things that only a tiny number of our customers will use or benefit from. I'm sure you understand."

WOW! I can't believe that! I will not be renewing my contract.

 

Which part can't you believe, exactly? I thought it made perfect sense, but I am biased.