Activity overview
Latest activity by DenisJCilliers
The Flyway option to Ignore case is not working properly
It does not ignore case when the setting is enabled nor does it script out the case changes when the setting is not enabled.Thus I have a Stored Procedure that is constantly found as changes to the...
Nice Script That is a very interesting script, and a clever way to create migrations, I might just look at doing the same thing just with the deployment scripts. --i-agree-to-the-eula I understand that the marketing guys have an issue with the eula, but they really need to chill and not ask us to keep putting --i-agree-to-the-eula in very command line. [image] , Take it as stated that if we are using the product we agree to the terms - as this is 5x in one short script / comments
Nice ScriptThat is a very interesting script, and a clever way to create migrations, I might just look at doing the same thing just with the deployment scripts.--i-agree-to-the-eula I understand th...
Seems that the product has become deprecated in favor of Flyway @ 5 times the cost... WOW So no chance this change will take place now .... / comments
Seems that the product has become deprecated in favor of Flyway @ 5 times the cost... WOWSo no chance this change will take place now ....
There is one flaw with this approach in that it would deploy the full database and not the difference between databases. I was looking to create the deployment script that is generated from one database to another as separate scripts. / comments
There is one flaw with this approach in that it would deploy the full database and not the difference between databases. I was looking to create the deployment script that is generated from one da...
Separate Scripts for each object in deployment scripts
Is it possible to generate separate scripts for each object for deployment, as the generate script creates one large script with all the changes in one file.
Also tried direct connection connection "C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe" /source USER/USER_PASS@server:1521:service{SCHEMA}/snapshot C:\Agent1\_work\100\s\output\Target_SCHEMA_1.0.0.21.onpWith this I also get error Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E
Schema Compare for Oracle Command Line - Product version: 6.0.23.1366
Populating database
Error: ORA-01017: Message 1017 not found; No message file for product=RDBMS, facility=ORA
70 / comments
Also tried direct connection connection"C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe" /source USER/USER_PASS@server:1521:service{SCHEMA}/snapshot C:\Agent1\_work\100\s\output\Targe...
Sry the command was wrong I needed to add a colon "C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe" /source:USER/USER_PASS@XE{SCHEMA} /snapshot C:\Agent1\_work\100\s\output\Target_SCHEMA_1.0.0.21.onBut there does seem to be an issue with TNS in Powershell As I now get Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E
Schema Compare for Oracle Command Line - Product version: 6.0.23.1366
Error: No TNS Entry for XE found, trying to connect using Oracle home
OraDB21Home1
Populating database
Error: Error while trying to retrieve text for error ORA-12154
70 / comments
Sry the command was wrong I needed to add a colon"C:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe" /source:USER/USER_PASS@XE{SCHEMA} /snapshot C:\Agent1\_work\100\s\output\Target_SCH...
Resolved it seems that my local Tnsnames.ora was missing an environment variable TNS_ADMIN C:\Oracle\product\21c\homes\OraDB21Home2\network\admin / comments
Resolved it seems that my local Tnsnames.ora was missing an environment variable TNS_ADMIN C:\Oracle\product\21c\homes\OraDB21Home2\network\admin
TNS:listener does not currently know of SID
I cant seem to get the sco.exe command line to connect using direct modeC:\Program Files\Red Gate\Schema Compare for Oracle 6\sco.exe /direct /source:user/password@server.map.ie:1521/xepdb1{schema}...