Settings and activity
93 results found
-
71 votes
An error occurred while saving the comment -
14 votes
An error occurred while saving the comment What you could try is to create a view in database2 that does the necessary join, and map the table against the view. Would that work?
-
3 votes
An error occurred while saving the comment @John - it's possible to exclude object types entirely using the checkboxes. Were you hoping for something different?
@Serge - does this existing filter functionality not work for you?
-
3 votes
An error occurred while saving the comment What source control system are you using? You may be able to configure that to validate a comment for a ticket number, for example.
-
14 votes
An error occurred while saving the comment If you're doing search and replace and want to include multiple objects, one tip would be to use the multi-select ability and script as ALTER ability of the Object Explorer Details pane. I describe this in more detail here: https://www.simple-talk.com/blogs/2012/04/24/ever-wondered-what-the-object-explorer-details-window-is-for/
An error occurred while saving the comment Are you aware that you can press F12 when the cursor is on an object? This scripts it to a new window as ALTER. The option is also on the context menu when you right click on an object in a query window.
-
3 votes
An error occurred while saving the comment Could you explain a little how you got yourself into the situation where you are undoing a drop to get something that is missing? Understanding the root cause will help us better construct a solution.
-
13 votes
An error occurred while saving the comment Would it be more useful if we put the modify (script as ALTER to a new query window) option in the Commit Tab context menu?
An error occurred while saving the comment Thanks, Benny. It would help us to know what you mean by "continue working on things" means. What key functions in the Object Explorer are you using once you've found the object there?
An error occurred while saving the comment This could be a nice idea, but we'd like to understand the problem you'd like to solve. What function in the Object Explorer are you looking to access?
-
1 vote
An error occurred while saving the comment Are you hoping for a way of right clicking on a database in SSMS and finding an option to "Create new database from this one"?
-
4 votes
An error occurred while saving the comment Did that make sense? It's not a simple thing to work out so we're hoping to have this as a built-in option in future. If you have any trouble getting this working, email me at david dot atkinson at red-gate dot com and I'll send you the template file as an attachment.
An error occurred while saving the comment That's because you're technically not interacting directly with Subversion any longer, only a working folder. So the steps are: Select More, then Manage Config Files. Copy one of the existing template files, rename it offlinesubversion (or similar), then edit the file and remove all the commands, which exist between the <CommandLine> tags. Also change the <Name> tag to be "SVN". When you save the file, you'll see a new entry in the dropdown, which you can now select.
An error occurred while saving the comment Which source control system are you trying to connect to? One approach would be to link using the "More" option, and use a 'blank' commandlinehooks file. This effectively allows you to save changes to a working folder instead of trying to talk to the source control system, leaving you to commit manually at a later date.
-
150 votes
An error occurred while saving the comment The original intent of the double click behavior on the results grid was to do a "Script as ALTER to a new Query Window. However, at the time we didn't know how to do this, and the challenge was to complete the tool in one week (see http://play.buto.tv/sHcbr for more details). We know how to do this now but haven't been able to make the change. If we did, would this be what you need? We would still have "select object in object explorer" as a context menu option.
-
78 votes
An error occurred while saving the comment Sadly we can't as there's no permanent team working on SQL Search. Resource may be allocated to the general SSMS productivity area in the latter half of the year. Personally I'd like to see "script as ALTER" as the default double click action rather than "Select object in Object Explorer", which would be relegated to a context menu. This was the original intention when the tool was designed, but somehow it never happened. I'd also like to see the number of search results as a configurable option. And for non-programmatic objects (eg tables), I'd like to see these scripted out in the lower panel.
-
1 vote
An error occurred while saving the comment Have you tried using the Filter feature to address this?
-
10 votes
An error occurred while saving the comment Aren't you able to select all the conflicts in one go, select "keep mine" and commit them en masse?
-
88 votes
An error occurred while saving the comment Thanks for the request. This is something we're keen on doing, especially as the popularity of the dacpac/bacpac format increases. Please continue voting for this if this is something you're now using. I'd be interested to learn more about what you're using these 'snapshots' for.
-
135 votes
Hi – this request was closed when the ‘TFS work items’ feature was released. http://documentation.red-gate.com/display/SOC3/Committing+changes
However, we’re still hearing about this enough that I’d agree with commenter Ben: it should be reopened.
We will continue to gauge interest here on UserVoice. Please do tell us more in the comments about what you expect to be able to do with Work Items in SQL Source Control.
An error occurred while saving the comment @alex - unfortunately due to finite development resource at our disposal even the simple things have to be prioritized alongside all the very long list of backlog items we have for SQL Source Control. We're trying our best to release as many valuable features as we can! Hope that one day we can meet your requirements!
An error occurred while saving the comment @Anonymous - we hope to put this into v4 but this isn't due out until next year. In the meantime you can use the #R and #A syntax to do the association. Or alternatively you can use SQL Connect.
An error occurred while saving the comment The 'started' was referring to the #R #A workaround. We're still keen to implement a work-item chooser dialog, although I wouldn't think it would be implemented before the second half of the year. Could you try using SQL Connect for this? This allows you to sync from your database to a VS project, which means you can associate with workitems in the normal way when you check in. SQL Connect works against the same repository as SQL Source Control. It's in preview at the moment: http://www.red-gate.com/products/sql-development/sql-connect/
An error occurred while saving the comment @Remi - the #A and #R codes in the comment is the only mechanism for now. We are hoping to add a UI around this at some point, but we have no firm timescales just yet.
-
7 votes
An error occurred while saving the comment Isn't that what is displayed in the difference viewer on the commit tab?
-
1 vote
An error occurred while saving the comment @Brent - would a post-deploy script work for you if we implemented something like this? ie, a script that gets appended to SQL Compare's deployment script.
An error occurred while saving the comment -
18 votes
An error occurred while saving the comment Have you tried creating your own commandlinehooks file for this?
-
8 votes
An error occurred while saving the comment Thanks for the request. Do you have so many items in the commit list that it is hard to find them? It would be interesting to understand how many you have on average.
-
215 votes
An error occurred while saving the comment We have a Beta build of SQL Compare that works with SSDT database projects.
http://www.red-gate.com/EAP/SQLCompareEAP/SQLCompareVS
After we get some feedback on this, we'll integrate the technology into SQL Source Control, which will mean the tools should play nicely with each other. As SQL Source Control uses the SQL Compare engine under the hood, it's very important for you all to let us know if it works for you, so we know what needs fixing before integrating with with SQL Source Control itself. Email any feedback directly to me at David.Atkinson@red-gate.com
An error occurred while saving the comment Is continuous integration the only thing that you want from VS database projects? If so, we have more information about how to set up continuous integration and Red Gate tools at www.red-gate.com/ci .If this isn't quite what you are looking for I'd like to understand what your needs are (I've emailed you directly).
An error occurred while saving the comment We've recently released SQL Connect, which is our source control story in Visual Studio. I'd urge everyone who has voted on this suggestion to give it a go and let us know how you get on. If you feel that you still need database project support, please let us know why! http://www.red-gate.com/products/sql-development/sql-connect
An error occurred while saving the comment @John - we'll definitely notify everyone if/when we do. In the meantime we're keen to get feedback on SQL Connect and whether this would be a useful extension to Visual Studio. I'd encourage all those who have posted to this forum to take a look and provide feedback - the more use engagement, the easier it is for us to justify database project support! http://www.red-gate.com/products/sql-development/sql-connect/
An error occurred while saving the comment @David - Can't you use the schema compare tool in VS to pull changes from your development database to the Database Project? There's no way just yet to sync the files in SQL Source Control with the Database Project files.
An error occurred while saving the comment @David - out of interest, what do you currently use for DB unit testing?
It is possible to select all (ctrl-a), then copy using the right click menu, and paste into Excel, for example.