Posts
Sort by recent activity
No option to exclude dependencies from schema model update
When I go to commit a change using Flyway Desktop, the "schema update" will almost always include extra artifacts that I did not choose. These are listed as dependencies, but due to my data model (...
Why does my Deployment scripts folder change?
One of my favorite features is the ability to have SQL Compare automatically save scripts for me when I have the tool execute a deploy. This provides a great way for me to go back and see what I'v...
Unable to connect to SQL Managed Instance
I can connect to on-premise resources just fine, but when I attempt to connect to a SQL Managed Instance I receive the following error: The problem occurs with both the "Integrated Authentication" ...
MFA Active Directory Authentication Error
I'm trying to connect to a SQL Managed Instance using the new 'Active Directory universal with MFA Authentication' authentication type, but running into an error. The security team on my end follow...
Redgate query blocked by ALTER TABLE ALTER COLUMN
Right now, I'm running an ALTER TABLE ALTER COLUMN statement in one of my databases. While that's running, there's a blocked SPID (program_name = 'Red Gate Software - SQL Tools') that's attempting ...
Azure Active Directory Authentication
I tried to launch dependency tracker against a SQL Managed Instance hosted in Azure today, and found that only two authentication types are available - Windows Authentication and SQL Authentication...
Commit all objects with 'Add database USE statement'
I was asked to ensure that the "USE Database" command be included at the top of all scripts in our database, and assumed that checking the "Add database USE statement" option at the top of the Comp...
Can database references be replaced during deployment?
My team currently follows an environment deployment process that places our development, test, and Production databases on separate servers. Within our current loads, we often have scripts that co...
Error in deployment script for table rebuild with computed columns
When attempting to deploy a change that
necessitated a table rebuild, and
included a computed field
My deployment script ran into an error: invalid column name "MyTable.MyColumn".
Invest...
Find Invalid Objects cannot detect nonexistent tables in trigger
When I look in a database for invalid objects, it cannot detect triggers that reference tables that do not exist.
Since I use triggers to maintain referential integrity, this can bite me if I ever...