Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Change the name on the first line to:
    name="Portal"
  • If you have registered your old project to a DMC DB (newer) or an AuditDB (older), remove the projectsId entry such as:

    Remove the projectsId content from: 

    Code Block
    projectsId="ec91d5b7-bf95-4249-af7f-f06dde742cb9"

    to 

    Code Block
    projectsId=""


  • Edit your database connections by editing the matching DbDefs.
    • You will need to use the UI to enter a different password. If you do not have access to the UI, you can Base64 encode the password as the value in the datical.project.
    • You will need to change the managed database or schema(s) information in the new project.
    Be sure to edit your "changelog" tag to remove any reference to the original project name. Alternatively, you can simplify it to:<changelog href="Changelog/changelog.xml#//@databaseChangeLog"/>
    • Remove the projectsId content from: 

      Code Block
      dbDefsId="3cc01c15-727a-34c1-ba97-5aafd139b839"

      to 

      Code Block
      dbDefsId=""


  • Edit your plans.
    • Remove the plansId content from: 

      Code Block
      plansId="b5e83263-beff-3eb6-8f41-0d1881ee330e"

      to 

      Code Block
      plansId=""


Your file should look like

Code Block
<?xml version="1.0" encoding="ASCII"?>
<dbproject:Project xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dbproject="http://datical.com/db/project/1.0" name="Portal" storedLogicExternal="true" deployThreshold="stopOnError" requireOptions="true" projectsId="" runtimeCredentials="false" multiSchema="true" dbSchemaDefinition="project" schemaSelectionStep="REF1" trackingSchema="DATICALDBTRACKING" enableRowCount="true">
  <dbDefs xsi:type="dbproject:OracleDbDef" name="REF1" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="REF,REF1" storageOptionCollectedAtSnapshot="true" labels="current" dbDefsId="" serviceName="CMS_REF1" enableCompression="false" rowsPerBatch="10000"/>
  <dbDefs xsi:type="dbproject:OracleDbDef" name="REF2" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="REF,REF2" storageOptionCollectedAtSnapshot="true" labels="next" dbDefsId="current" serviceName="CMS_REF2" enableCompression="false" rowsPerBatch="10000"/>
  <dbDefs xsi:type="dbproject:OracleDbDef" name="DEVINT1" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="DEVINT1DEV, DEVINTDEVINT1" storageOptionCollectedAtSnapshot="true" labels="current" environmentdbDefsId="DEV" serviceName="CMS_INT1" enableCompression="false" rowsPerBatch="10000"/>
  <dbDefs xsi:type="dbproject:OracleDbDef" name="DEVINT2" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="DEVINT2DEV, DEVINTDEVINT2" storageOptionCollectedAtSnapshot="true" labels="next" dbDefsId="current" serviceName="CMS_INT2" enableCompression="false" rowsPerBatch="10000"/>
  <dbDefs xsi:type="dbproject:OracleDbDef" name="QA" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="QA" storageOptionCollectedAtSnapshot="true"  labelsdbDefsId="current" serviceName="CMS_QA" enableCompression="false" rowsPerBatch="10000"/>
  <dbDefs xsi:type="dbproject:OracleDbDef" name="PROD" driver="oracle.jdbc.OracleDriver" hostname="localhost" port="1521" username="DATICAL_USER" password="REFUSUNBTF9VU0VS" contexts="PROD" storageOptionCollectedAtSnapshot="true" labels dbDefsId="current" serviceName="CMS_PROD" enableCompression="false" rowsPerBatch="10000"/>
  <plans name="current" databaseDefs="//@dbDefs[name='REF1'] //@dbDefs[name='DEVINT1'] //@dbDefs[name='QA'] //@dbDefs[name='PROD']" plansId=""/>
  <plans name="currentnext" databaseDefs="//@dbDefs[name='REF2'] //@dbDefs[name='DEVINT2'] //@dbDefs[name='QA'] //@dbDefs[name='PROD']" plansId=""/>
  <changelog href="Changelog/changelog.xml#//@databaseChangeLog"/>
  <dmcDB xsi:type="dbproject:PostgresqlDbDef" name="DMCDB" driver="org.postgresql.Driver" hostname="dmc-db.liquibase.net" port="5432" username="datical_user" password="ZGF3aWNhbF91c9Vy" dbDefType="dmcdb" database="cs_dmc"/>
  <releaseLabels name="current AND !abandoned" description="Deploy changesets from the current pipeline that have not been abandoned"/>
  <releaseLabels name="hotfix AND !abandoned" description="Deploy changesetchangesets from the hotfix pipeline that have not been abandoned"/>
  <schemas name="TRAINING"/>
  <schemas name="APP_SCHEMA"/>
</dbproject:Project>

...

  1. Check your connections
  2. Update your passwords as needed
  3. Register your project in your DMC DB (newer) or your AuditDB (older)
  4. Run a status


...