How can we help you today? How can we help you today?
Dan Calver
Activity overview Badges (0) Articles (20) Posts (0) Comments (11)

Activity overview

Latest activity by Dan Calver

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
  1. Community
  2. Flyway (General Discussion)
  3. Flyway preventing access exclusive lock
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 ...
Edited 0 votes
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
  1. Community
  2. SQL Change Automation
  3. SQL Change Automation - Baseline does not capture Partition Scheme/Function
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...
0 votes
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
  1. Community
  2. SQL Change Automation
  3. SQL Change Automation static data sequence error
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...
0 votes
Hi Steven Vallarian  Could you please post the request here: https://redgate.uservoice.com/forums/141379-sql-compare / comments
  1. Community
  2. SQL Compare
  3. feature request - add paths to duplicate items
Hi Steven Vallarian Could you please post the request here: https://redgate.uservoice.com/forums/141379-sql-compare
0 votes
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
  1. Community
  2. SQL Prompt
  3. SQL Prompt suggestions not loading with dynamics SQL access
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: ...
0 votes
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
  1. Community
  2. SQL Prompt
  3. missing parameters after autocomplete
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.
0 votes
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
  1. Community
  2. SQL Clone
  3. Clone not shrinking if action cancelled
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...
0 votes
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
  1. Community
  2. SQL Server Products
  3. SSMS21: Support for dark mode
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! 
0 votes
I will pass the feedback along to the team, please consider voting on the request here: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/17571874-dark-theme#comments / comments Official comment
  1. Community
  2. SQL Data Compare
  3. Dark Mode for SQL Compare & SQL Data Compare
I will pass the feedback along to the team, please consider voting on the request here: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/17571874-dark-theme#comments
0 votes
Hi AlecS  If you wish to completely eliminate Sequences and Synonyms from the comparison, you can make use of the filter file on the left side of the UI.   [image]       / comments Official comment
  1. Community
  2. SQL Compare
  3. More selectivity in Sql Compare
Hi AlecS If you wish to completely eliminate Sequences and Synonyms from the comparison, you can make use of the filter file on the left side of the UI.    
0 votes
Total activity
45
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
14