Activity overview
Latest activity by joshsensus
I have not seen an issue with pure database metadata going missing, i.e. extended properties. The meta data I'm talking about is default data that is needed to be in certain tables to run our product. We have a wide variety of tables that contain data that only contains a full set of known data, tables that contain a mixture of default data + application user entered data (i.e. customizations), and tables that are 100% application user entered data (i.e. user data). The SQL Data Generator command line does a good job at populating the tables that are 100% user entered data but is lacking when generating data and keeping data in the other 2 types of tables mentioned. The request would be to add the /exclude options like in SQL compare and to allow the generator to add data without truncation or delete. / comments
I have not seen an issue with pure database metadata going missing, i.e. extended properties. The meta data I'm talking about is default data that is needed to be in certain tables to run our prod...
I have built a test harness to deploy 20+ different previously released versions of our product. These databases change on a daily basis depending on the tests being run. I've incorporated running the SQL Data Generator into the test harness before we upgrade each of the test databases to the current version that is being developed. The Redgate tool is being run via the command line for each database independently prior to attempting the upgrade to the current version. Creating a generic sqlgen file isn't a possibility as our product has schema changes in every release and each one of the 20+ test databases will be different from each other. The sqlgen files allow for tables to be added to instead of truncated / deleted but the command line does not offer that option. I'm trying to keep all of our meta data in tact without having generated meta data for each one of the 20+ databases. / comments
I have built a test harness to deploy 20+ different previously released versions of our product. These databases change on a daily basis depending on the tests being run. I've incorporated runnin...
Can I add data without truncating via command line?
I'm trying to generate data while keeping application meta data present (200+ tables) without truncating all of it via the command line. Is there a way to do this?I'm not running a sqlgen file as ...
This is also appearing for the SQL tools as I had just used the oracle versions as an example. / comments
This is also appearing for the SQL tools as I had just used the oracle versions as an example.
When does the automation pack get the latest updates?
I currently have licenses for the SQL Developer Bundle and Oracle Deployment Suite on my local machine, and have the automation pack on a build server and have noticed that the versions in the auto...
exit code signifying successful run with differences
I'm running both versions of Schema Compare for Sql Server and Oracle via command line in the automation pack. Is there an exit code that I can catch in my application that would signify that diff...
Unfortunately running projects isn't ideal as we have a variable amount of schemas to compare against as part of some unit testing. I have been able to run via command line using some other logins that are created as part of our product. This only worked after upgrading to the latest upgrade that was made available last week.
If the functionality to run as sysdba could be added in the near future that would be great! / comments
Unfortunately running projects isn't ideal as we have a variable amount of schemas to compare against as part of some unit testing. I have been able to run via command line using some other logins ...
syntax to connect as sysdba in command line?
Is there any way to connect as sys as sysdba via the command line? I can do it through the UI but want to automate the compares and report generation in the same way that we run the UI.
Thanks in ...