Liquibase configuration is tied to Elastic Path's Maven configuration settings. Therefore, you must modify the Maven settings.xml file.

1. In your home directory, create a .m2 directory.
2. With SVN, checkout the settings.xml used by the developers into your .m2 directory.
3. With a text editor, open settings.xml.
4. Scroll down to <activeProfiles> and uncomment the appropriate -dev-db profile for your production database. Be sure to comment out all other available database profiles.
5. Add the following bit of XML under <profiles>:

   <profile>
   	<id>YOUR_DATABASE_PROFILE</id>
   	<properties>
   		<epdb.schemaname>COMMERCEDB</epdb.schemaname>
   		<epdb.username>ep</epdb.username>
   		<epdb.password>ep</epdb.password>
           <epdb.host>127.0.0.1</epdb.host>
           <epdb.port>YOUR_DATABASE_PORT</epdb.port>
   	</properties>
   </profile>
   

   Note: Oracle Database Profile

   If you are using Oracle 11g, use the following profile instead and replace epdb.databasename with the name of your database:

   <profile>
   	<id>oracle-dev-db</id>
   	<properties>
   		<epdb.databasename>orcl</epdb.databasename>
   		<epdb.schemaname>COMMERCEDB</epdb.schemaname>
   		<epdb.password>ep</epdb.password>
           <epdb.host>127.0.0.1</epdb.host>
           <epdb.port>1521</epdb.port>
   	</properties>
   </profile>
   

   Note: Default settings

   Elastic Path 6.14.0 uses the following database profile values by default:

   Schema Name	COMMERCEDB
   Username	ep
   Password	ep
   Host	127.0.0.1

   All default database settings are defined in the Elastic Path grandparent POM. You may override any setting by adding the new value in your settings.xml database profile.

6. Replace the id property with your production database's -dev-db profile. For example, mysql-dev-db
7. Replace the epdb.schemaname property with the name of your database schema.
8. Replace the epdb.username and epdb.password properties with an account that has permission to access your database.
9. Replace the epdb.host and epdb.port properties with your database server's IP and port numbers.