Search
-
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… -
Re: Adding a second base monitor - Azure DB specs + migrating monitored servers?
1. If you're running in a vCore model you can just use the requirements posted here: https://documentation.red-gate.com/sm11/installation-and-setup/planning-the-sql-monitor-infrastructure-and-installation/sql-monitor-database-requirements If your on-prem setup uses 1 core per 5 SQL servers (hypothetical example) you can… -
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… -
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… -
Re: How to configure remote oracle db?
Hi, thank you for your forum post. I assume you are referring to Source Control for Oracle application. Not 100% sure what you mean by the comment: Source Control for Oracle (SOCO) is designed to operate on user's Windows workstation or laptop. You just need to create a new project, of which there are 5 steps: * Step 1,… -
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… -
how to format values clause on merge
VALUES (1, 0, N'Base Type', N'Base Type', 0, 1, '2019-05-29T18:53:19.4700000', '2019-05-29T18:53:19.4700000', 1, 1, 1), (2, 0 , N'EntityMasterRecord', N'Entity Master Record', 1, 1, '2019-05-30T13:30:08.4633333', '2019-05-30T13:30:08.4633333', 1, 1, 1 ) Would like to format each values on single line (1, 0, N'Base Type',… -
DLM Automation Build
Hi I am getting below error while running build in Teamcity Changes are made in sql table C:BuildAgentpluginsdlmautomation-teamcity-agentDLMAutomationRunner.ps1 : [11:02:27][Step 1/1] Could not compare "0" to "5 14 1 10 16 15 5 17 9 17 5 12 26 12". Error: [11:02:27][Step 1/1] "Cannot convert the "System.Object[]" value of…
>5989 results