Comments
Sort by recent activity
Hi Tomas,
Firstly, apologies for the very late response. I see you've since had conversations with my colleague Ben, but for completeness, and for anybody else who comes across this, I have attempted to answer your questions below.
Regarding a way to achieve getting a database in sync with a new branch in source control: the easiest way is using our Schema Compare tool to compare from a check out of the files to the database server. Using this tool you can enforce the direction and thus achieve what you were hoping.
Regarding Get Latest: this feature was designed for users who decide to set up private (aka "sandboxed" or "dedicated") schemas for each member of the team, not for branch switching. So if Ben and I are both working on our our own private versions of a schema, both linked to the same repository, I can use Get Latest to retrieve changes made by Ben that are not in my schema. We use our schema comparison technology to make changes in a sensible, data preserving and dependency aware way.
I hope that helps. Ideally we'd like to introduce a much simpler "switch branch" feature in a later version, but it's not something we have immediate plans for.
Best regards,
Michael Christofides
Product Manager / comments
Hi Tomas,
Firstly, apologies for the very late response. I see you've since had conversations with my colleague Ben, but for completeness, and for anybody else who comes across this, I have attempt...
Hi Lauri,
Firstly, apologies for the slow reply.
If you are still hitting problems, please do say and we can open a proper support ticket.
Expected behaviour for us would be to show you an "Error! Open to view details" message on the projects screen, and then some form of detailed message on opening that which would then offer you an "Edit credentials" hyperlink.
Best regards,
Michael Christofides
Product Manager / comments
Hi Lauri,
Firstly, apologies for the slow reply.
If you are still hitting problems, please do say and we can open a proper support ticket.
Expected behaviour for us would be to show you an "Error! ...
Hi Dehilster,
We do support triggers so I'm not entirely sure why they might not be showing. Is there any chance you've deselected them in the filter? Or are they perhaps in the section of identical objects?
If not, the other thing to check is whether the username used for the comparison has the right permissions to be aware of the triggers.
Hope that helps and apologies for the slow response.
Michael Christofides
Product Manager / comments
Hi Dehilster,
We do support triggers so I'm not entirely sure why they might not be showing. Is there any chance you've deselected them in the filter? Or are they perhaps in the section of identica...
This might be relevant: http://documentation.red-gate.com/displ ... es+project / comments
This might be relevant:http://documentation.red-gate.com/displ ... es+project
Hi Paule,
Sincere apologies for the delayed response, I dropped the ball on this one.
This is not currently easy to do. Unless you have a huge number of users and projects we'd strongly advise against trying this, but it can be done with some messy copying and editing of some folders and config files (not for the feint hearted).
If you are interested in the feature but are also willing to wait for us to implement it in the user interface, it would really help to know your precise use-case.
For example:
1. whether your team would all be working on the same development database?
2. how many projects they'd have (roughly) each?
3. how often people would add or remove projects, and why
4. roughly how many schemas there would be in each project (1, "a few", "lots" would all be reasonable answers!)
The messy workaround is to copy all of the content in the location:
%localappdata%\Red Gate\Source Control for Oracle 2
You'll then need to edit at least the config file:
LinkedDatabases.xml
Which contains users specific information about where that folder is located. For example for me to use projects set up by my colleague Ben Tozer, I had to run a find and replace on that file to change "ben.tozer" to "michael.christofides" in multiple places.
If anybody reads this and has answers to those questions and/or questions about this, please don't hesitiate to get in touch.
Best regards,
Michael / comments
Hi Paule,
Sincere apologies for the delayed response, I dropped the ball on this one.
This is not currently easy to do. Unless you have a huge number of users and projects we'd strongly advise agai...
Hi Dave,
Thank you for trying, and sorry to hear that. We'll raise a support call and get in touch our help-desk for some additional information to diagnose this.
Michael / comments
Hi Dave,
Thank you for trying, and sorry to hear that. We'll raise a support call and get in touch our help-desk for some additional information to diagnose this.
Michael
Hi Dave,
Sincere apologies for totally having missed your messages.
A while back we did fix an error with virtual columns and scripts folders so I'd be hopeful that this would work should you be interested in trying our the latest version, direct link here: http://download.red-gate.com/Deployment ... Oracle.exe
Best regards,
Michael Christofides
Product Manager / comments
Hi Dave,
Sincere apologies for totally having missed your messages.
A while back we did fix an error with virtual columns and scripts folders so I'd be hopeful that this would work should you be in...
Hi, sorry for the delayed response.
What is your desired behavior here? Depending on that you have a couple of options.
If the primary key could be the same for two records that you want to keep, you should set a different comparison key. By default we choose the Primary Key for this, but you can change it, details on how to do so here: http://documentation.red-gate.com/displ ... to+compare
If, however, the same primary key implies that you only want to overwrite the data in the target machine, simply keeping this row selected in the comparison results when you start the deployment wizard will result in a script which will alter that row.
In either case foreign keys will be respected.
Hopefully that helps, do say if we've misunderstood.
Michael / comments
Hi, sorry for the delayed response.
What is your desired behavior here? Depending on that you have a couple of options.
If the primary key could be the same for two records that you want to keep, y...
Hi Paule,
I work with Neil on the Oracle team, as Product manager I feel perhaps locking is still a confusing feature of the tool.
Our aim with locking was to provide teams working on shared development schemas a means by which to 1) avoid clobbering each others' changes accidentally and 2) communicate what they were working on to one another.
The use case you describe is something we see less, but that we understand would be valuable to some teams working on separate, sand-boxed, development schemas. We currently see a better long-term solution to that problem to be to offer a "merge" to the second person, but in the meantime we currently offer a "take mine" or "take theirs" to resolve the conflict. There is nothing stopping you at that point going to either the database or the file system and merge the object yourself.
Hopefully that helps?
Best regards,
Michael / comments
Hi Paule,
I work with Neil on the Oracle team, as Product manager I feel perhaps locking is still a confusing feature of the tool.
Our aim with locking was to provide teams working on shared develo...
Hi, thank you for doing this! Unfortunately we don't have a team actively on the MySQL tools at the moment, but we'll log this. I'm glad to hear you have a workaround for now, and thanks again for sharing it for any others who hit this.
Best regards,
Michael / comments
Hi, thank you for doing this! Unfortunately we don't have a team actively on the MySQL tools at the moment, but we'll log this. I'm glad to hear you have a workaround for now, and thanks again for ...