Where do we submit feature requests for datadude?

Question

Hello,

I have noticed that submitting an idea for Visual Studio at COnenct now redirects to http://visualstudio.uservoice.com/forums/121579-visual-studio. There's no way I am putting datadude feature requests up there - they'll never be seen again.

How do I get feature requests in front of the datadude team these days?

thanks
Jamie

P.S. Here is what I want to submit:

On my project we have checked the box for "Generate DROP statements for objects that are in the target database but not in the database project". Unfortunately we are not attempting to deploy the database and coming up with this error:

*** SQL01268○D:\BLD\9\27\Binaries\DB.sql○(484,0)○.Net SqlClient Data Provider: Msg 15151, Level 16, State 1, Line 1 Cannot drop the user 'APPDEV\TFS Admins', because it does not exist or you do not have permission.

In other words, there are security objects that are required (by the DBAs) to be in the database but should not be part of the database project.

Solution: We need an option to "Ignore users & roles" when the "Generate DROP statements for objects that are in the target database but not in the database project" checkbox is checked.

 

 

---

http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 1

Hi,

I found that just as you mentioned above, there is indeed no appropriate category for the data-dude feature requests. Maybe we should just put the feature requests which about the database project to the visual studio category list.

Do you mean after you submite one feature request, you can not find the link again?

Answer 2

Do you mean after you submite one feature request, you can not find the link again?

No, I mean that if I add datadude feature requests into a list of Visual Studio feature requests they will sink down and down into oblivion and no-one will ever take any notice of them. It was fine when feature rquests were submitted at connect.microsoft.com because you could categorise it as "database tools" (something like that anyway) and hence those requests went direct to the datadude team. There is no such mechanism on Uservoice.

Its also worsened by the fact that the datadude team are now part of the SQL Server org so why would they bother checking some 3rd party site that is dedicated to an organisation they are no longer a part of? I know I wouldn't. The beauty of Connect, for all its many many faults, is that submissions could be routed to the correct team within Microsoft.

 

---

http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 3

I 100% agree with your request about the Users issue.  I had asked the DataDude team at PASS Summit 2009 about this very issue because I was having this problem in the VS 2008 version, obviously still waiting for something like you are suggesting. 

Currently, you have the options to ignore permissions (IgnorePermission) & ignore rolememberships (IgnoreRoleMembership) in the .sqldeployment file, but not the users.  Though, if you do a Schema Compare rollout you can ignore specific objects from the compare such as users which would be great if it was also available on the Deployment side of things.  As in your case, I have worked in shops that the developers weren't directly in control of Users & Role Membership (though we were in control of DB roles).  It really does mess things up when you have the "Generate DROP statements..." option selected for deployment. 

The only workarounds related to this issue I am aware of involves multiple database projects and keeping certain objects in different projects.  Of course, then you won't be able to effectively use the "Generate DROP statements..." option.

I hope someone sees this post and has a better solution.

You got my vote when we find out where to request this.  I will definitely be asking about the permissions & user stuff again at PASS 2011 because I get to go this year :).

Answer 4

  I will definitely be asking about the permissions & user stuff again at PASS 2011 because I get to go this year :).

Good. Please hammer tham about it :)

---

http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me