Search
-
How to make all types of merged assemblies internal?
I am using the following construct in my saproj: <Assembly AssemblyName="MyCompany.LibA, Culture=neutral, PublicKeyToken=null"> <Merging Merge="1"> <Pruning> <Exclusion /> </Pruning> <Obfuscation Obfuscate="1"> <Exclusion /> </Obfuscation> <ControlFlow Obfuscate="1" /> <MemberRefsProxy /> <ResourcesCompression />… -
Missing indentation after WHILE
* SQL Prompt version: 10.14.4.4865 * SQL Server Management Studio version: 19.2.56.2 * SQL Server Version: * Microsoft SQL Azure (RTM) - 12.0.2000.8 * Microsoft SQL Server 2022 (RTM-GDR) (KB5029379) - 16.0.1105.1 (X64) * Database Compatibility Level: 160 * Active Style: Default Before formatting DECLARE @i INT = 1; IF @i =… -
Ignoring an entire Schema
I will compare database for MSSQL but I want to ignore schema differences. As an example I will compare two databases 1.Database Name : A2.Database Name : B Schema of database A A1schema of database B B1 gives me the following output as an example. A1.ExampleTable in database A does not exist in database B. But I have the… -
Behaviour of SQL*Plus @@ command
@) is used within a script file to execute another script file contained in the same directory@ functions exactly the same as @. I have a file "V23.0__install.sql" whose content is the following: @tables.sql @indexes.sql ... The "tables.sql" script is located in the same directory as the V23.0__install.sql" file. However… -
JSON_OBJECT causes Incorrect syntax near ':'.
While trying to deploy a DB project using a PS1 script the following error occurred: "Incorrect syntax near ':'" 'JSON_OBJECT( ''DemographicID'':1 ABSENT ON NULL) as payload' Using the above string in the creation of a dynamic INSERT command causes the error. I have tried numerous ways to work around this, but any attempt… -
PLSQL_ARCHIVE Missing from Generation Script
When running the generated script for a schema compare with a blank schema CREATE SEQUENCE dev.seq_wt_wkshop_tt_cancel MINVALUE 0 NOCACHE; ... This is the first line of the gene script and I get the following error 4 ORA-04088: error during execution of trigger 'DEV.PLSQL_ARCHIVER_TRG' ORA-00604: error occurred at… -
Re: is skipExecutingMigrations available on Community Edition
The artifact is stored in my teams artifactory. Ot Spring deployable is built with Gradle: api group: 'org.flywaydb', name: 'flyway-core', version: '10.9.1' Let me explain what I needed to do. I have some deployment thats have migrations applied, lets say up to 107. There are 110 migrations. For deployment at 107, I want… -
Change automation plugin broken under Visual Studio 17.9
Hi. After upgrading to Visual Studio 17.9, the change automation pluggin is broken. It is impossible to show the dialog to change the DB connection. Clicking the button does nothing and we found this in the log : Error|RedGate.Versioning.Client.VsShell.VisualStudio.ConnectionDialog.VisualStudioConnectionDialog|1| Error in… -
Re: How to link my db to source control Azure DevOps?
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… -
SQLprompt not working with SSMS 19. All other tools in sqltoolbelt working
The SQLPrompt not working in SSMS 19.x onwards. I use other software in SQLToolbelt and works fine. The log shows its already installed but I have verified the RedGate install directory and add or remove programs, the prompt is not available. Tried installing using SQLtoolbet exe as well as standalone SQL prompt exe. Any…
>5978 results