We are using the SQL Compare CLI to do state based deployments based on the schema-model folder as defined by Flyway. As I was reorganizing the files to accommodate this, I needed to put the RedgateDatabaseInfo.xml file in the root of the database folder (i.e. .../Database/RedgateDatabaseInfo.xml) but once I worked with the Flyway again it decided this file was missing and attempts to recreate it in the schema-model folder (i.e. .../Database/schema-model/RedgateDatabaseInfo.xml). Is there a SQL Compare CLI option to specify a path to the xml file or a setting in the Flyway project that can be updated that instructs Flyway to the preferred location for this file?
Comments
2 comments
-
Hi Josh,
Thanks for reaching out to Redgate Support. So with respect to the RedgateDatabaseInfo.xml file, after doing a preliminary search through our documentation, I do not see a manner in which you can change the default location of the .xml file. Here is what I found:
= = = = = = = =
https://documentation.red-gate.com/sc/using-the-command-line/using-xml-to-specify-command-line-argumentsScripts folder database information file
When you create a scripts folder, an XML file containing some basic details about the structure of the database is created. The file is called RedGateDatabaseInfo.xml and is stored in the main scripts folder at the top level.
If the file does not exist when you run the comparison, SQL Compare creates it, using the default values.
= = = = = = = =
Additionally, checking through Flyway documentation, I do not see any CLI or parameters for editing the path.
https://documentation.red-gate.com/flyway/reference/commands
https://documentation.red-gate.com/flyway/reference/configuration
-
Thanks, I believe I have been able to successfully adjust our deployment script to account for this.
Add comment
Please sign in to leave a comment.