Comments
Sort by recent activity
Hi,
Sorry to hear that you're experiencing this problem. Is this problem repeatable? If it is, do you have any antivirus software running at the same time? If so, you might want to try disabling it temporarily to see if that has anything to do with it. / comments
Hi,
Sorry to hear that you're experiencing this problem. Is this problem repeatable? If it is, do you have any antivirus software running at the same time? If so, you might want to try disabling it...
Hi,
I'm not sure if I've understood or not, so please feel free to correct me if I've made a mistake. Are you wanting to include changes that have been committed directly to trunk but exclude any changes that have been merged in from another branch?
If that's what you want then unfortunately you won't be able to do it with our tools. Could you possibly utilise an additional branch for merging your changes? That might have a similar effect. / comments
Hi,
I'm not sure if I've understood or not, so please feel free to correct me if I've made a mistake. Are you wanting to include changes that have been committed directly to trunk but exclude any c...
Hi @shaimakem2 , Is the Redgate toolbar hiding somewhere like this? - [image] If you can see it checked when you right click on the toolbar then SSMS may have decided to add it into a gap that is too small for any of the buttons to be visible. One thing you could also try is to disable the other toolbars to verify that the Redgate toolbar becomes visible. Once you know where it is, you can drag it to a new row so that it can fully expand. / comments
Hi @shaimakem2 ,Is the Redgate toolbar hiding somewhere like this? - If you can see it checked when you right click on the toolbar then SSMS may have decided to add it into a gap that is too small ...
@MikeyLikesIt - SQL Search supports SSMS 17.1, although you will have to uninstall it and then reinstall to get it to install into 17.1. @Rushabh - As far as I'm aware, SQL Search should work with an Azure database. Have you tried reindexing the database? Have a look at this documentation page for more help - https://documentation.red-gate.com/display/SS2/The+search+results+aren't+what+I+expected - if you're still having trouble then I'd recommend that you contact our support team. / comments
@MikeyLikesIt - SQL Search supports SSMS 17.1, although you will have to uninstall it and then reinstall to get it to install into 17.1.@Rushabh - As far as I'm aware, SQL Search should work with a...
Hi!
Just to confirm that the documentation is correct, I set up a test user account on my local instance and gave it the permissions described in the documentation. This worked correctly and I was able to commit and retrieve stored procedures.
What is db_execproc - I don't think that's a standard role. What happens if you remove the user from that role? Is it possible that you might have a DENY permission somewhere that is overriding other permissions? / comments
Hi!
Just to confirm that the documentation is correct, I set up a test user account on my local instance and gave it the permissions described in the documentation. This worked correctly and I was ...
Hi,
SQL Data Generator is not really designed for deploying data from one table to another. If you really want to use SQL Data Generator then you can map an existing data source to your table. Selecting SQL Table or View as the source type and pointing SQL Data Generator to the first table would get this to work, although you wouldn't have the control that you may desire - for instance you wouldn't be able to filter the results.
In my opinion, it sounds like SQL Data Compare would be a better match for your use case. Here are some worked examples that use SQL Data Compare to deploy data from one database to another. In your case, you would simply select only the table that you are interested in for deployment. If you want to filter your data based on a criteria then you can apply a WHERE clause to your comparison.
I hope this helps. / comments
Hi,
SQL Data Generator is not really designed for deploying data from one table to another. If you really want to use SQL Data Generator then you can map an existing data source to your table. Sele...
Hi Scott,
Sorry to hear you're experiencing this problem. The error message is suggesting that a file in your repository is locked, so I don't think it's referring to SQL Source Control's locking feature - that is for locking objects within the database. It's possible that it might be locked within TFS itself. I'd recommend investigating to see if there's anything odd going on in there that might be preventing you from committing. / comments
Hi Scott,
Sorry to hear you're experiencing this problem. The error message is suggesting that a file in your repository is locked, so I don't think it's referring to SQL Source Control's locking f...
Thanks for your suggestion! IgnoreKeys is actually an option rather than a switch, so its documentation can be found on the options page. / comments
Thanks for your suggestion!IgnoreKeys is actually an option rather than a switch, so its documentation can be found on the options page.
Hi,
I've created a support ticket for this issue and you should receive an email shortly. / comments
Hi,
I've created a support ticket for this issue and you should receive an email shortly.
Hi Sebastian,
Ah, this explains things and I'll try to explain what is going on. We are trying to build a series of scripts. Script files don't really have a concept of database name as they are just flat files representing individual objects. When you use three part naming, the parser assumes you are referring to an external dependency that doesn't need to be built and this can result in an incorrect deployment order.
To fix this, you'll need to adjust these references to remove the database name. / comments
Hi Sebastian,
Ah, this explains things and I'll try to explain what is going on. We are trying to build a series of scripts. Script files don't really have a concept of database name as they are ju...