slow-cheetah
slow-cheetah copied to clipboard
sayedihashimi
No transform support in SQL Server Database project
For VS 2012 Sql Server Database projects there is no Add Transform menu item for .xml files, like it is in other project types. This would be really handy to have transforms for database publish profiles.
Hi I'm not that familiar with these projects. Can you be more specific what you are looking for?
Hi,
What I am trying to achieve is transformations for xxx.Database.publish.xml.
Please see attachment - there is no menu item for adding transforms to this file.
Thanks, Uldis
2012/10/29 Sayed Ibrahim Hashimi [email protected]
Hi I'm not that familiar with these projects. Can you be more specific what you are looking for?
— Reply to this email directly or view it on GitHubhttps://github.com/sayedihashimi/slow-cheetah/issues/38#issuecomment-9856458.
Sorry I still don't understand the end goal. All you are telling me is that the menu item is not showing up. I can make the item show up but I don't understand what the expectation is for the behavior. Sorry if I'm being dense, but I don't use DB projects.
The end goal is to achieve simiral experience as with Web Projects. To have TargetConnectionString replaced at compile time by transform, so that I can easily copy it out to Deployment package. It seems that Database projects do not jet support the cool Publishing profiles in MSBuild option (DeployOnBuild=true;PublishProfile=Release), or it is not that well documented. Sure, I can employ TranformTask in MSBuild file, but it would be great to have this feature baked in. Probably I'm beeing the dense one :laughing:
Ok cool thanks that helps. Publish Profiles are only supported for web projects. Since DB projects don't have the concept of publish profiles if this feature is implemented it would create transforms based on build config. Would that still be helpful here? If so I can look into this.
As a side note, I have heard some feedback that we should support a similar concept to profiles. I think we may be able to do, but I need to look into it further. I have created an issue for this at #48
In order to prioritize work I created http://slowcheetah.uservoice.com. If you care about thus feature please create a suggestion there. We will only be working on the most voted items.