Comments
Sort by recent activity
Thank you for reporting the issue and sorry for the inconvenience. We'll fix this asap. Thanks / comments
Thank you for reporting the issue and sorry for the inconvenience. We'll fix this asap. Thanks
By default SQL Source Control run that script to show which objects has changed in the object explorer. You can disable this option if you want or adjust the polling frequency in the Options dialog. [image] / comments
By default SQL Source Control run that script to show which objects has changed in the object explorer. You can disable this option if you want or adjust the polling frequency in the Options dialog.
The missing "Manually Edit the Script" link was a known bug. It was fixed in version 7.0.46.9898 / comments
The missing "Manually Edit the Script" link was a known bug.It was fixed in version 7.0.46.9898
You can customize the connection string for the shadow database to point to any SQL Server instance locally or remotely. You must specify one as the tool need to be able to drop/create the shadow database in order to perform the various operations successfully (import/apply/verify). More info is available here https://documentation.red-gate.com/sca4/developing-databases/concepts/shadow-database / comments
You can customize the connection string for the shadow database to point to any SQL Server instance locally or remotely. You must specify one as the tool need to be able to drop/create the shadow d...
I am not aware of any argument you can provide to get the behavior you expect. The last option you suggest can be achieved using a pre-script but I would be very concerned to drop production unintentionally. So I suggest the second option of adding an extra step to drop the database before calling SCA. Add this extra step only when you deploy to transient environments. / comments
I am not aware of any argument you can provide to get the behavior you expect.The last option you suggest can be achieved using a pre-script but I would be very concerned to drop production uninten...
We are aware of some problems related to Pre-Update and Post-Update in the latest release when using static data (3.3.19217) and we have a fix we intend to release next week. Let us know if that will fix your issue otherwise please contact support and we can investigate further. / comments
We are aware of some problems related to Pre-Update and Post-Update in the latest release when using static data (3.3.19217) and we have a fix we intend to release next week. Let us know if that wi...
It would be useful if you can provide a copy of your project so we can investigate further. Please contact support via email. Thanks / comments
It would be useful if you can provide a copy of your project so we can investigate further. Please contact support via email.Thanks
I agree it's not the greatest experience but if you click Commit you will be able to see the detailed list of warnings and decide to cancel the operation if you don't want to proceed by clicking the Cancel button. You can review each warning individually and make the right call. This is how the dialog looks after you try to commit: [image] ...and this is a list of all the possible warnings you can get with a reason of why the deployment could fail or cause data loss: https://documentation.red-gate.com/sc13/deploying-data-sources/deployment-warnings/full-list-of-deployment-warnings / comments
I agree it's not the greatest experience but if you click Commit you will be able to see the detailed list of warnings and decide to cancel the operation if you don't want to proceed by clicking th...
Unfortunately, I think Azure Active Directory authentication is not yet supported in SQL Source Control. This is the related user voice entry if you want to cast your vote: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/16531591-support-azure-active-directory-authentication Sorry for the inconvenience [image] / comments
Unfortunately, I think Azure Active Directory authentication is not yet supported in SQL Source Control.This is the related user voice entry if you want to cast your vote:https://redgate.uservoice....
The latest version of SQL Prompt (10.4.2) now supports Azure Active Directory - Universal with MFA authentication. Could you please try it out and let us know if it works? Thanks / comments
The latest version of SQL Prompt (10.4.2) now supports Azure Active Directory - Universal with MFA authentication. Could you please try it out and let us know if it works? Thanks