Comments
Sort by recent activity
Hi monolith There is a behavior option in Schema Compare for Oracle to detect renamed columns. [image] However the above option is not available in Data Compare for Oracle. If you are comparing from script files, it is possible that the files still have reference to the old table / column names. It might be worth re-creating these if changes, such as the renamed table, occur again in the future. Likewise, it might be worth setting up a new project just in case of these references. / comments
Hi monolith There is a behavior option in Schema Compare for Oracle to detect renamed columns. However the above option is not available in Data Compare for Oracle.If you are comparing from script...
Hi @Alex_197 Unfortunately, as of version 10.7, support for 2008 and 2008r2 was removed. Additionally, support for 2022 was being added from around 10.12. Since SQL Prompt can't have multiple installs on the same machine, it's a bit tricky in your situation. Upgrading to 14 gives you support for 2022, but as you've noticed, it removes support for 2008r2. Your best bet here would be to install the version which supports the one you will be mainly using. You can use this link to download whichever version you need. / comments
Hi @Alex_197 Unfortunately, as of version 10.7, support for 2008 and 2008r2 was removed. Additionally, support for 2022 was being added from around 10.12. Since SQL Prompt can't have multiple insta...
Hi @jaket1998 The link that I highlighted should always be a download of the base monitor for the version of the web service you have installed. This file comes from the web folder, which means that whenever the web service is installed, that base monitor .exe comes with it. Regarding your comment: "When I go there it does show the current version im running. Is it supposed the be the current version or is there supposed to be an updated base installer I need for the script?" It's supposed to be the current version. For the URL you are using to pull down the downloader, this version is currently 14.0.0.7, just like the version you have displayed in your screenshots, but if you want the latest version now to test, you can pull it from the following link: https://download.red-gate.com/checkforupdates/RedgateMonitorWebService/ Try manually downloading this version for now, and then run your script after extracting the .msi. After it installs the web service, manually check the web folder (C:\Program Files\Red Gate\SQL Monitor\Web\wwwroot\Download) and see what version of the base monitor .exe it has. It should be displaying the same version as the web service you have downloaded. / comments
Hi @jaket1998 The link that I highlighted should always be a download of the base monitor for the version of the web service you have installed. This file comes from the web folder, which means tha...
Hi jaket1998 That's strange that its picking up a previous version. If you head into the Settings > Configuration > Base Monitors and manually check the download link, what does it show? [image] You can also double check the file manually by going into the Download folder and going into the Properties > Details screen of the .exe: C:\Program Files\Red Gate\SQL Monitor\Web\wwwroot\Download / comments
Hi jaket1998 That's strange that its picking up a previous version. If you head into the Settings > Configuration > Base Monitors and manually check the download link, what does it show?You can als...
Hi @Shahani_DFW90_Aug Redgate Monitor can help you to evaluate the efficiency with which your workload utilizes server resources (CPU, Throughput, Memory) and to identify problematic statements or execution plans. This in turn allows you to tune anything that these processes pick up. With regards to tuning, Redgate Monitor doesn't offer any options to do this automatically, but instead assists you in picking up inefficient statements/queries/plans that it may pick up. This can be through alerts or by simply reviewing the overview screen on your severs. / comments
Hi @Shahani_DFW90_Aug Redgate Monitor can help you to evaluate the efficiency with which your workload utilizes server resources (CPU, Throughput, Memory) and to identify problematic statements or ...
Hi @Shahani_DFW90_Aug Redgate offers integration with Service now, which you can find more about through this documentation page: https://documentation.red-gate.com/monitor/integrating-with-servicenow-239668090.html It also offers the ability to send notifications through services such as Pager Duty (SMS messages) https://documentation.red-gate.com/monitor/pagerduty-sms-notifications-239668069.html As well as the ability to generate slack messages. https://documentation.red-gate.com/monitor/setting-up-slack-notifications-239668070.html However, with our custom webhooks, you could integrate with most applications that support it: https://documentation.red-gate.com/monitor/setting-up-webhook-notifications-239668082.html / comments
Hi @Shahani_DFW90_Aug Redgate offers integration with Service now, which you can find more about through this documentation page: https://documentation.red-gate.com/monitor/integrating-with-service...
This was logged as a support ticket and the answer to this question is that SQL Compare doesn't actually support the output of DML triggers to an individual folder when going from Database -> Scripts folder. SQL Compare considers DML triggers to be part of a table script, so they get included in the table create scripts. If your scripts folder already contains both separate table scripts and DML triggers in their own sub folders, SQL Compare has the capability to identify references to the table, so SQL Compare will pick up those DML triggers and add them to the relevant table script for deployment. / comments
This was logged as a support ticket and the answer to this question is that SQL Compare doesn't actually support the output of DML triggers to an individual folder when going from Database -> Scrip...
This was resolved through a support ticket, but for anyone else running into a similar error, here are some of the troubleshooting steps we went through: Delete your SQL Source Control cached credentials file 1. Close SSMS. 2. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 7 3. Delete Credentials.XML. 4. Restart SSMS and link the database again. SQL Source Control should prompt for credentials. Delete your cached credentials 1. Close SSMS. 2. In Control Panel, go to Credential Manager (or Network Credentials, depending on your version of Windows). 3. Remove your TFS credentials. 4. Restart SSMS and link the database again. SQL Source Control should prompt for credentials. Manually create TFS credentials 1. Close SSMS. 2. In Control Panel, go to Credential Manager (or Network Credentials, depending on your version of Windows). 3. Add a new credentials entry for your TFS sever, user name, and password. 4. Restart SSMS and link the database again. SQL Source Control should prompt for credentials. Also, here is an article that may help: https://developercommunity.visualstudio.com/t/tf30063-you-are-not-authorized-to-access-after-pas/151627 Apart from that, if the issue is still not resolved, an uninstall and re-install of SSMS and Visual Studio could help. / comments
This was resolved through a support ticket, but for anyone else running into a similar error, here are some of the troubleshooting steps we went through:Delete your SQL Source Control cached creden...
Hi @vshclover I attempted to do a quick replication of your issue, on version 7.0.7, as well as the latest 7.0.11, and the 'Ignore system named constraint and index names' option is seemingly working for me. Instead of using the .json file, would you be able to try the 'Static data & comparison' option shown below in my screenshot? Also, as I have been unable to replicate it on a later version, would you be able to try updating to see if you can still replicate it? https://download.red-gate.com/checkforupdates/FlywayDesktop/FlywayDesktop_7.0.11.0.exe [image] [image] / comments
Hi @vshclover I attempted to do a quick replication of your issue, on version 7.0.7, as well as the latest 7.0.11, and the 'Ignore system named constraint and index names' option is seemingly worki...
Hi @vshclover That's definitely quite strange. I've tested this a few ways and cannot seem to replicate your findings. Can you try this for me?
Navigate to the project files > Schema-model > Tables
Delete one of the table scripts where this issue is occurring on
Refresh the Schema model tab in flyway
Enable the 'Ignore system named constraint and index names' option
Save the table to your project
Let me know if if continues to appear in the schema-model screen with the ignore option set after doing these steps. / comments
Hi @vshcloverThat's definitely quite strange. I've tested this a few ways and cannot seem to replicate your findings.Can you try this for me?
Navigate to the project files > Schema-model > Tables
D...