User profile for Peter_Laws

Hello maxschafintact, I'm sorry to say this functionality isn't one of the features of the Prompt CLI. You could suggest it on the dedicated customer feature request forum to see if there might be more members of the community interested in the same. https://redgate.uservoice.com / comments

Hello maxschafintact, I'm sorry to say this functionality isn't one of the features of the Prompt CLI.You could suggest it on the dedicated customer feature request forum to see if there might be ...

0 votes

Oh interesting! Noted, thanks, I've mentally shifted gears; in which case by default Flyway Desktop ignores collations differences (as defined here) please could you check your SQL Change automation project for the corresponding 'SyncOptionIgnoreCollations' project definition? If the input is consistently the correct collation the easiest remediation for the moment may simply be to ignore. / comments

Oh interesting!Noted, thanks, I've mentally shifted gears; in which case by default Flyway Desktop ignores collations differences (as defined here) please could you check your SQL Change automation...

0 votes

Hello fwin, While it is intentional (a consequence of the underlying comparison engine) it is something we are looking to change as it can be confusing or misleading. Such as in the scenario where multiple developers are committing with very slightly different versions of db. I'll add your experience to the existing task for this. May I ask why you needed to add it manually? I'd expect it to be dynamically populated from source. / comments

Hello fwin,While it is intentional (a consequence of the underlying comparison engine) it is something we are looking to change as it can be confusing or misleading. Such as in the scenario where m...

0 votes

Hello BFLAHERTY, Terribly sorry to read you hit this issue, we'll try to replicate this with a view to correcting it. Please could you let us know the following, if you'd rather do so privately, please let us know that instead and we can create a support call for you. Version of Source Control Version of Oracle Brief example of a faulty commont (unless all comments are affected) How the comments are being populated / comments

Hello BFLAHERTY,Terribly sorry to read you hit this issue, we'll try to replicate this with a view to correcting it.Please could you let us know the following, if you'd rather do so privately, plea...

0 votes

Hello cbarbosa, I'm sorry to read you hit this issue. The profiler has various built in exception handlers to address various things it can't manage, given the exception you hit I'm inclined to say that you've either hit a permission issue or the dump file itself may be malformed. Please could you run a check against it and let us know the findings? https://docs.microsoft.com/en-us/windows-hardware/drivers/debugger/dumpchk / comments

Hello cbarbosa,I'm sorry to read you hit this issue. The profiler has various built in exception handlers to address various things it can't manage, given the exception you hit I'm inclined to say ...

0 votes

Thanks for talking me through it, now I have a better understand I spoke to our developers about it, it's not something we're looking to incorporate soon due to the degree of reworking this would require of the build task. We'll retain the feature request however for future use, I'm sorry we don't have a better answer for you. / comments

Thanks for talking me through it, now I have a better understand I spoke to our developers about it, it's not something we're looking to incorporate soon due to the degree of reworking this would r...

0 votes

Thank you for explaining, is it a temporary solution due to how manual it is and a smoother workflow would be prefered? (perfectly reasonable) or is there some missing functionality please? / comments

Thank you for explaining, is it a temporary solution due to how manual it is and a smoother workflow would be prefered? (perfectly reasonable) or is there some missing functionality please?

0 votes

I don't believe Smart Assembly's support of single file executables has changed since .NET Core 3, however I think what you're describing was covered by that also. Does this guide differ from your present workflow please? https://documentation.red-gate.com/sa/building-your-assembly/using-smartassembly-with-single-file-executables-net-core-3 / comments

I don't believe Smart Assembly's support of single file executables has changed since .NET Core 3, however I think what you're describing was covered by that also.Does this guide differ from your p...

0 votes

Hello tg_dev3, Thank you for the fantastic question! That article encapsulates well many of the issues teams are facing, even more so in the scenario you're describing where the implementations are complex, as they tend to be the most change aversed for (sometimes justifiable) fear of unintended consequences. The development configuration normally needs to go hand in hand with a dev or branching strategy, in your description you're looking at moving from the proverbial 'single source of truth' to potentially many and that can make people apprehensive. This article discussed some of the advantages to dedicated development environments. https://documentation.red-gate.com/fd/development-database-environment-configuration I think the most pertinent, due to your cited complexity is increased accuracy of version control alignment. As for how, the most common approach broadly is as follows. The main trunk / branch / safe and current version, is checked into a shared repo Dev starts a new task, branches off main Pulls down / clones repo locally* Develops locally and checks into said branch Once work is complete, tests passed etc, the branch can be merged back into main Should they wish to collaborate with colleagues, they can just checkout their peers branch for as long as they need it. Much like the containers you were mentioning, a large part of this is disposability, due to being smaller, faster and simpler. The underpinning principles of DevOps is that you can build, little and often and that makes things commensurately easier to track and iterate on. As a somewhat simplistic example, historically rollbacks have been a critical component of deployment strategies, but they don't really align with the DevOps ethos (as always, there are exceptions). The DevOps preference is to roll forwards, if there was an unintended consequence, don't undo, but rather do again, with a fix. However in times past when releases were less frequent, the updates were large, unpicking what went wrong was as a result more complex, slower. Rolling back was typically more reliable, yes you may lose some data, but you knew it was a safe state.With the advent of 'little and often' rolling forward without loss is now considerably more viable because there's a lot less to analyse, the actual deployment itself will likely be faster too. On the topic of productivity, I'll drop back to the personal dev vs shared briefly, there's also potential gains for the protection afforded by local dev, the probability for disruption in a shared space is much higher, naturally care and defensive coding practices are important, but devs will also be sinking time into ensuring their changes don't directly impact others work and you may never see return on that investment if all goes according to plan. The loss of productivity in a shared environment is a constant risk that has to be managed. Most of this has been conceptual, so I'll dedicate a portion to a practical implementation of how does everyone get their own SQL Server instance? These recommendations are somewhat governed by your environment, development practices, dev count regarding scalability etc. At the most basic level, every dev could simply have a test db running on their machine, the simplicity has its merits and the setup complexity is low. It's robust, not particularly resource intensive and has minimal requirement on 3rd party elements. This can help keep the complexity of your security considerations down. Infrastructure as code - this is your Docker'esk territory, a lightweight script language defines setup behaviour, you run the code and it implements the image / application / infrastructure you defined. This has a higher initial setup complexity, but once created, you can be confident absolutely everyone who uses it, get the same thing. Depending on the scope of your implementation that could be client and server side, in fact you could create an image that encapsulated everything the a dev is permitted if you were so inclined! That last part could be a bit restrictive, I have seen some companies do that were they have extremely strict security practices, a whole development environment container is provisioned per person per project and then disposed of after, most people probably don't need to go that far, but it is possible. There may also be cloud based offering that provide a comfortable middle ground, for example Azure provide a subscription based SQL Server, they take care of all the infrastructure, you just connect to it with your prefered IDE and continue just as you did when it was on-prem. The actual implementation is what best fits your companies many needs, be they security, resourcing, speed, and you'll know that better than we will. However I will say you're asking all the right questions, the direction you're looking will make your development and deployments faster, more robust and once your devs are accustomed to it, it should even be easier too! Thanks again for asking, it's this curiosity that we're looking to encourage in the community, please don't hesitate to come back to us if you have follow up queries. *there are many tools to achieve this, we have some nice ones. The degree of rigor, complexity and speed you require for your devs should guide this however. / comments

Hello tg_dev3,Thank you for the fantastic question!That article encapsulates well many of the issues teams are facing, even more so in the scenario you're describing where the implementations are c...

0 votes

Do you happen to know if the v7 & v8 projects are using the same settings please? Without knowing exactly what obfuscation options you're using it's just an estimation presently, but if you're using string encoding that could potentially be an issue also and you can exclude the method from such in a similar manner as referenced in the same article. If that fails, should wish to, we'll could create a support incident for you to share your project for us to examine? / comments

Do you happen to know if the v7 & v8 projects are using the same settings please? Without knowing exactly what obfuscation options you're using it's just an estimation presently, but if you're usin...

0 votes

How can we help you today?

Peter_Laws

Comments