Activity overview
Latest activity by Christian Perez
Hi Adrian, Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your SQL Clone installation. Given your description, this sounds like a potential file-lock/sharing violation on the VHD. To clear the current stuck image/clone: 1. Identify the machine that created the image/clone. 2. Open Disk Management on that machine. 3. Find the row for the Database VHD matching the stuck image/clone (it'll be in the image folder, with a sanitized version of the image name, ending in .vhd). 4. Right-click it and select Detach VHD. 5. Retry the delete via the GUI or PowerShell module. - If you can't locate it in Disk Management, restarting the machine that stores or created the image will also release the lock. When you are deleting the images, are you utilizing Remove-SqlCloneImage -Soft or what powershell syntax are you utilizing? Remove-SqlCloneImage -Soft should remove the image from SQL Clones internal tracking without touching the file, you can then queue the leftover file for manual deletion. For clones however, there is no soft-delete, so you would have to do the steps above. Give the above steps a shot and let me know if you still cannot remove the images/clones from your application. / comments
Official comment
Hi Adrian, Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your SQL Clone installation. Given your description, this sounds like a potential file-lock...
Good Morning Victor Bogolyubov, thanks for reaching out to Redgate Support regarding your issues with TFS and Source Control, I have seen this “headToWorkingBase didn't get set” in the past, but I need to get your full set of logs so I can see if there are any other corresponding error entries that would give us additional context. Could I trouble you to attach your SQL Source Control log files for me to review? You can find instructions on how to pull the logs here: https://documentation.red-gate.com/soc/troubleshooting/logging-and-log-files By default, log location will be %LOCALAPPDATA%\Red Gate\Logs / comments
Official comment
Good Morning Victor Bogolyubov, thanks for reaching out to Redgate Support regarding your issues with TFS and Source Control, I have seen this “headToWorkingBase didn't get set” in the past, but I ...
Hi David, Thanks for reaching out to Redgate Support regarding your issue with SQL Compare. I know you already mentioned not having any ‘ignore’ option set for constraints, but I do believe this exact scenario of the name being the only difference in the constraints is why the IgnoreConstraintAndIndexNames option is provided. You can find details on this option on this page: https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options#Settingprojectoptions-Ignoreconstraintandindexnames Here is a snippet of the definition “Ignores the names of indexes, foreign keys, primary keys, and default, unique, and check constraints when comparing views, tables and table-valued types. If an index or constraint differs in ways other than its name then its name won't be ignored when it is deployed.” Can you try the above project option and let me know if it fixes the reported behavior? / comments
Official comment
Hi David,Thanks for reaching out to Redgate Support regarding your issue with SQL Compare. I know you already mentioned not having any ‘ignore’ option set for constraints, but I do believe this exa...
Hello Abhinandan & brian.burge , appreciate your patience while we worked on this issue. This behavior has been remediated in the Flyway CLI engine version v12.6.0. https://documentation.red-gate.com/flyway/release-notes-and-older-versions/release-notes-for-flyway-engine Could I trouble you to update your Flyway CLI engine to 12.6.0 or newer and then test your Databricks parsing is functioning as intended now? / comments
Hello Abhinandan & brian.burge , appreciate your patience while we worked on this issue. This behavior has been remediated in the Flyway CLI engine version v12.6.0.https://documentation.red-gate.co...
Hi Davraf, Thanks for reaching out to Redgate Support, apologies for the display issue you appear to be experiencing. I am including a screenshot below of what you should be able to do to fix this behavior: [image] If you click on the 6 dots in the bottom right-hand corner you should be able to re-size the suggestions window. This behavior is generally caused by the resolution of the screen you are working on, so if you can increase the resolution even temporarily, you should get around this behavior. If you cannot increase resolution or re-size the window, you may have to move your Windows taskbar to the left hand side of the screen, re-size the window, then move the taskbar back to the bottom. Should be as easy as drag and drop the toolbar. (might have to unlock it) Can you give the above steps a shot and let me know what the results are? / comments
Official comment
Hi Davraf,Thanks for reaching out to Redgate Support, apologies for the display issue you appear to be experiencing. I am including a screenshot below of what you should be able to do to fix this b...
Hi Dave P, Hope you are doing well today, sorry to hear you are having a little trouble with your Flyway CLI when trying to pass your own SQLFluff through. Could I trouble you for the full CLI syntax you are utilizing? Better yet, if we could get the relevant portion of your GitHub Actions workflow YAML, specifically the steps for setting up Flyway, Python/SQLFluff, and running the flyway check command, that should give us more context as to where to look next. Reviewing what you have provided thus far, setting the environment variable to FLYWAY_ENV_NATIVE_SQLFLUFF=false seems the correct step to take if you are utilizing your own SQL Fluff application. One thing to note on the environment variable, is to ensure that the environment variable is created in an environment that the GitHub Actions pipeline has access too. That being said, I am curious if perhaps we also need to pass in a check.code.sqlfluffEnabled parameter in the CLI syntax to get this to work. Including some documentation below in case its helpful. https://documentation.red-gate.com/flyway/reference/commands/check/check-code https://documentation.red-gate.com/fd/flyway-check-rules-config-setting-306940980.html https://documentation.red-gate.com/fd/flyway-check-sqlfluff-enabled-setting-296816565.html Lastly, if you add a -X to the Flyway check command, you can run the command in debug mode and it may give you better information as to what the exact cause is. Best, Christian Perez Product Support Engineer / comments
Official comment
Hi Dave P,Hope you are doing well today, sorry to hear you are having a little trouble with your Flyway CLI when trying to pass your own SQLFluff through. Could I trouble you for the full CLI synta...
Hello Abhinandan & brian.burge , thanks for your patience, I had to stand up a sample Databricks environment which took a little time. I have now confirmed the behavior and this indeed appears to be a limitation with how the Databricks parser is handling Scripts that have multiple statements delineated by ; symbols. I am escalating this behavior up the developers to be remediated. Thank you for bringing this to our attention. / comments
Hello Abhinandan & brian.burge , thanks for your patience, I had to stand up a sample Databricks environment which took a little time. I have now confirmed the behavior and this indeed appears to b...
Hi Huey, The information you are looking for should be able to be pulled if you utilize the REST API available with Redgate Monitor Enterprise, if you have the proper license of course. If you are a Standard Monitor Subscriber however, I would give Thomas Bishops sample script above a shot and see if it gets you those details, https://documentation.red-gate.com/monitor/rest-api-in-monitor-enterprise-240976357.html / comments
Official comment
Hi Huey,The information you are looking for should be able to be pulled if you utilize the REST API available with Redgate Monitor Enterprise, if you have the proper license of course. If you are a...
Hi Sean, Thanks for reaching out to Redgate Support regarding your SQL Doc inquiry. I did a search through the codebase repository and SQL Doc Documentation, but unfortunately I am not seeing a method to exclude grant/deny/revoke statements from the SQL Script section of documented objects outside of exluding SQL Scripts entirely from the documentation. I would recommend you consider creating an entry on our User Voice Forum here: https://redgate.uservoice.com/forums/936348-sql-toolbelt-essentials Our User Voice Forum allows Redgate End Users to create potential enhancement requests that are then voted on by the community, if other members vote on your topic, it can then be implemented by development in a future release. Let me know if you have any follow up questions. / comments
Official comment
Hi Sean,Thanks for reaching out to Redgate Support regarding your SQL Doc inquiry. I did a search through the codebase repository and SQL Doc Documentation, but unfortunately I am not seeing a meth...
Hi Bogdan, Thanks for performing those tests for us, throughout the time you were monitoring the GDI Objects level, did you see a crash behavior at any point? / comments
Hi Bogdan, Thanks for performing those tests for us, throughout the time you were monitoring the GDI Objects level, did you see a crash behavior at any point?