How can we help you today? How can we help you today?

Path to RedgateDatabaseInfo.xml

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?
josh_stcu
0

Comments

3 comments

  • cperez
    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-arguments

    Scripts 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



    cperez
    0
  • josh_stcu
    Thanks, I believe I have been able to successfully adjust our deployment script to account for this.
    josh_stcu
    0
  • Aura Same

    Thanks for the clarification. I’ve adjusted our deployment script to reflect this and everything appears to be functioning correctly.

    flash games

    Aura Same
    0

Add comment

Please sign in to leave a comment.