Comments
Sort by recent activity
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...
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.
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 ...