Comments
Sort by recent activity
You might want to post this on the UserVoice site then: https://redgate.uservoice.com/forums/94413-sql-prompt . This is probably the best way for others to weigh in on how important it is to them. / comments
You might want to post this on the UserVoice site then: https://redgate.uservoice.com/forums/94413-sql-prompt . This is probably the best way for others to weigh in on how important it is to them.
This was seemingly released in version 10.15.0 (November 2024), with a few fixes and enhancements since: Added the ability to show the aggregate values of a selection of cells in the results grid. When I select a range of cells, I can right-click and do Show Aggregate Results, which shows things like COUNT and DISTINCT for string values and COUNT, DISTINCT, SUM, AVERAGE, MIN, and MAX for numerics. / comments
This was seemingly released in version 10.15.0 (November 2024), with a few fixes and enhancements since:Added the ability to show the aggregate values of a selection of cells in the results grid.Wh...
I'm not sure if this is the cause of your problems but did see in the release notes for 14.28.0: Fixed an issue where SQL Server backups were not shown on the Estate > Backups page, and backup overdue alerts were raised incorrectly, when the database name recorded in the backup history differed in case from the actual database name. Many of my backup overdue alerts appeared to be due to this. The database would be named something like “HR_PROD” but msdb would contain backup records for “hr_prod”, and thus Monitor would complain about not finding backups for HR_PROD even though it was regularly receiving all its backups. / comments
I'm not sure if this is the cause of your problems but did see in the release notes for 14.28.0: Fixed an issue where SQL Server backups were not shown on the Estate > Backups page, and backup over...
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors. When it comes to actually deploying the changes, that might be more a question of your CI/CD rules. One team I work with has the standard that each deployment target has a branch (so a beta branch, a main/production branch) and any new migrations are first merged into those branches before deployment occurs. / comments
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors.When it comes to actually deploying the ...
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move anyone's changes to any environment. So for example, Team 1 will start their migrations at number 10000, Team 2 will start with 20000, and Team 3 will start with 30000. That gives you 10,000 migrations per team until you run out. At that point you should probably be doing a rebaseline anyway. / comments
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move a...
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351) [image] One downside is that you cannot use “Match whole words only” to insist that each term is a whole word. (For example, to exclude matches of “Donec” for “nec”.) That will make it search for both words together as a phrase ("nec ipsum"). I do agree, it would be preferable to have support for more “standard” search operators like quotes and maybe some AND/OR logic. / comments
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351)One downside is that you cannot use “Mat...
Have you restarted the Azure pipeline service since you set up Flyway? I just ran into this myself in Azure DevOps. Agent service was up, I added the Flyway key, and ADO just refused to read it even though it was clearly and correctly set in the system PATH environment variable. I just had to open Services and restart the corresponding Azure Pipeline Agent service. / comments
Have you restarted the Azure pipeline service since you set up Flyway?I just ran into this myself in Azure DevOps. Agent service was up, I added the Flyway key, and ADO just refused to read it even...
Just running flyway auth or rather flyway auth -IAgreeToTheEula didn't work as they complained about me being offline. --- I was able to get it working with an offline permit as described on the Licensing page. I originally misunderstood what I needed to run and was trying to do flyway auth -offlinePermitPath=wherever , which would still say I was offline. Rather, the file just needs to be present somewhere and then you can proceed to invoke the other Flyway verbs. For example, flyway version -offlinePermitPath=wherever returns Enterprise as desired. Or if you set up the environment variable FLYWAY_OFFLINE_PERMIT_PATH as described on the offline permit path page, then you don't have to pass the argument either. --- Another, somewhat less convenient, approach I found was that running "C:\Program Files\Git\git-bash.exe" in the terminal launched by Flyway will open a new Git Bash terminal in the current working directory with the REDGATE_LICENSING_PERMIT variable still set, which sets it up with Enterprise from the get-go. / comments
Just running flyway auth or rather flyway auth -IAgreeToTheEula didn't work as they complained about me being offline.---I was able to get it working with an offline permit as described on the Lice...
I've done something like this with SQL Server. 1. Change your development database link to point to prod 2. Save any updated objects into your schema model 3. Change your development database back to dev 4. Use the Update development pane to push the changes from your schema model into the dev database Assuming test/uat also need to be updated, I would recommend generating the migration script and using that to deploy to test/uat, then doing a skipExecutingMigrations move for prod. / comments
I've done something like this with SQL Server. 1. Change your development database link to point to prod2. Save any updated objects into your schema model3. Change your development database back to...