Comments
Sort by recent activity
Hi all, This is unfortunately an issue due to the changes in SSMS 21 & 22s with it's order of operations. To workaround this, if you open SSMS, open SQL Source Control tab, then close and re-open SSMS the icons should now display correctly / comments
Hi all,This is unfortunately an issue due to the changes in SSMS 21 & 22s with it's order of operations.To workaround this, if you open SSMS, open SQL Source Control tab, then close and re-open SSM...
Hi Benjamin, In this case, scenario B works because Snowflake will only consume the private_key_file when it's part of the JDBC URL. Does the private_key_file need to be variable? I would try something like the following ## Environment: Dev
[environments.dev]
url = """jdbc:snowflake://XXXXXX.snowflakecomputing.com?{$private_key_file_variable}\ Then you can set up your private_key_file as an environmental variable. / comments
Official comment
Hi Benjamin,In this case, scenario B works because Snowflake will only consume the private_key_file when it's part of the JDBC URL. Does the private_key_file need to be variable?I would try somethi...
Hi Vlad, Unfortunately, Flyway itself cannot change how PostgreSQL handles DDL locking. The ALTER TABLE ADD COLUMN command in Postgres requires an ACCESS EXCLUSIVE lock, which blocks read and writes to the table until the statement completes. This is a PostgreSQL behavior, not something Flyway can override. To change this, you could change the DDL statements, but that would require manual change. You're correct in your assumption, that property only affects its own flyway_schema_history table. / comments
Official comment
Hi Vlad,Unfortunately, Flyway itself cannot change how PostgreSQL handles DDL locking.The ALTER TABLE ADD COLUMN command in Postgres requires an ACCESS EXCLUSIVE lock, which blocks read and writes ...
Hi Max, This is default behaviour for a SQL Change Automation project, to change this for your existing project, please edit the .sqlproj file in notepad, then if you paste this into the file it will allow you to script partition schemes/functions. <SyncOptionIgnoreDataspaces>False</SyncOptionIgnoreDataspaces> Example: [image] / comments
Official comment
Hi Max,This is default behaviour for a SQL Change Automation project, to change this for your existing project, please edit the .sqlproj file in notepad, then if you paste this into the file it wil...
Hi Bo Ngoh Sorry, to hear you're experiencing this issue! I just tested this scenario myself without issue, so I'm wondering do you know what version of SQL Change Automation you're using? It could also be the case of different comparison options causing trouble. I'm happy to reach out directly via a support ticket to troubleshoot further if that works for you! / comments
Hi Bo Ngoh Sorry, to hear you're experiencing this issue!I just tested this scenario myself without issue, so I'm wondering do you know what version of SQL Change Automation you're using?It could a...
Hi Steven Vallarian Could you please post the request here: https://redgate.uservoice.com/forums/141379-sql-compare / comments
Hi Steven Vallarian Could you please post the request here: https://redgate.uservoice.com/forums/141379-sql-compare
Hi Timothy Jeffreys I'm afraid SQL Prompt does not support a Dynamics CRM that uses a Dataverse Database. If you would like to see this database supported in the future, please could you post here: https://redgate.uservoice.com/forums/94413-sql-prompt / comments
Hi Timothy Jeffreys I'm afraid SQL Prompt does not support a Dynamics CRM that uses a Dataverse Database.If you would like to see this database supported in the future, please could you post here: ...
Issue was investigated on a support ticket, and it was down to the configuration of the database being loaded for suggestions, followed by a refresh. / comments
Issue was investigated on a support ticket, and it was down to the configuration of the database being loaded for suggestions, followed by a refresh.
Hi, The growth with SQL Clone can come down to a few different factors, a few of which are documented here: https://documentation.red-gate.com/clone/troubleshooting/common-issues/the-files-behind-the-clone-have-grown-to-be-very-large / comments
Hi,The growth with SQL Clone can come down to a few different factors, a few of which are documented here: https://documentation.red-gate.com/clone/troubleshooting/common-issues/the-files-behind-th...
Hi Christian Linke I've put a request in for the team to have a look at whether we can support this. I'll keep you posted on updates! / comments
Official comment
Hi Christian Linke I've put a request in for the team to have a look at whether we can support this. I'll keep you posted on updates!