Comments
Sort by recent activity
So is it working now? I didn't get :-) / comments
So is it working now? I didn't get :-)
Hi @GunNut37086,
could you please send us the screenshot of the tooltip you're getting?
The right documentation link for your version is this one.
As the note states, you can turn off the box, following the instructions in the Showing or hiding the object definition box section.
If you've accidentally turned it off, you should see the SSMS toolbox, if the SSMS intellisense is on, or even nothing. / comments
Hi @GunNut37086,
could you please send us the screenshot of the tooltip you're getting?
The right documentation link for your version is this one.
As the note states, you can turn off the box, foll...
Hi @mweis,
I've found this post (I dunno if it's the one you were speaking of). It seems that you can contact support in order to check the activation limit. / comments
Hi @mweis,
I've found this post (I dunno if it's the one you were speaking of). It seems that you can contact support in order to check the activation limit.
Hi @Varwulf,
this one
that wants a job, or something similar that can be run on a whim, that will take all of the data in our Production environment and copy it out to our QA and Dev environments but there are some special parameters and requirements needed for this process.
is one of the most "long standing" problem when managing QA environment. How to bring "real" production data into the QA environments. Redgate has a great tool to do so, which is SQL Clone. I really suggest to give it a try.
About masking (or faking) data, one you've a cloned database, you can do anything you want to it, since it's completely isolated by the source (and the other clones). You can also mask a clone of the source, and then use that clone as the new source image, in order to create many copies of the, let's say, masked-cloned database.
Speaking about repeating this behavior (which is a DevOps approach, actually), you can use SQL Clone with PoSh or even Windows task scheduler.
I think that your requests aren't too much. I believe that we should approach repeatedly, when this is possible. By integrating other tools/services we've already in our companies, improving continuously, decreasing the technical debt, writing useful and pragmatic processes, we will also enhance our solutions. Don't you think?
Hope this helps / comments
Hi @Varwulf,
this one
that wants a job, or something similar that can be run on a whim, that will take all of the data in our Production environment and copy it out to our QA and Dev environments...
Hi rolando,
could you please try to do the same thing when using SQL Search? These are the repro steps:
open a window in SSMS with a non saved query (any query is good)
open SQL Search, search for something and let the detail pane open
try to select text into the detail pane and press CTRL-C
do you receive the same error? if so, you can read here. Unfortunately, seems to work in SSMS, but maybe it could be helpful to read about it in order to understand better the behavior. I'd like to get the way to solve it also in comparison tools. / comments
Hi rolando,
could you please try to do the same thing when using SQL Search? These are the repro steps:
open a window in SSMS with a non saved query (any query is good)
open SQL Search, search for...
Hi @Ballinhuge,
if you go to the project properties, you can specify only the where filter for comparing data (and also the columns to be considered). The comparison process should be made between objects, not queries. If you mean different Where conditions, you can (as described before) but otherwise, I guess you should compare the queries manually.
About the automation, the tool creates a deploy script and preview the differences for you, but when you compare objects.
Please, let me know if I got it correctly.
ciao, / comments
Hi @Ballinhuge,
if you go to the project properties, you can specify only the where filter for comparing data (and also the columns to be considered). The comparison process should be made between ...
Hi, we're using SoC and I've also developed a new version of automated database link (taken from your previous project), here: https://github.com/EngageITServices/SOCAutoLinkDatabasesWorkingFolder. We're really trying to implement a DevOps process for SQL Server, and we've just reached the goal to execute the comparison via Octopus Deploy. I'm really interested in your idea with ReadyRoll. Count me in if you would like to speak with me. Always glad to help.
ciao / comments
Hi, we're using SoC and I've also developed a new version of automated database link (taken from your previous project), here: https://github.com/EngageITServices/SOCAutoLinkDatabasesWorkingFolder....
Hi @AG57,
have you go a screenshot? Did you get the "send report" window? If so, could you please send here the stack trace of the error? I had the same issue, but I guess that the stack trace could be different for me. / comments
Hi @AG57,
have you go a screenshot? Did you get the "send report" window? If so, could you please send here the stack trace of the error? I had the same issue, but I guess that the stack trace coul...
I will try to send the complete DDL, but it was a release and I'm not sure to reproduce it.. / comments
I will try to send the complete DDL, but it was a release and I'm not sure to reproduce it..
micheleidesmith wrote:
Would this solve the problem for you?
Yes it will, and, if possible, let the system to choose the most used setting, that will be like a "default" setting. What do you think about that?
micheleidesmith wrote:
Can I ask if you use the SQL Compare project settings at the moment? If so, what do you use them for? What kind of settings do you save within your projects? E.g. project options, filters, mappings.
I use project settings to preset my filter on different branches to organize better the releases. When I started to use changesets instead of direct database I found the problem I described in the last post. This is the reason why I was asking. Using the contextual compare (right mouse compare/deploy) doesn't allow me to use a preconfigured project setting.
I have a complex scenario with 5 dev branches, the main line and one rtm line so merging/branching/migrating and releasing are my daily missions to accomplish.
Your proposed solution will be ok imho.
Thanks a lot / comments
micheleidesmith wrote:
Would this solve the problem for you?
Yes it will, and, if possible, let the system to choose the most used setting, that will be like a "default" setting. What do you th...