Differences
This shows you the differences between two versions of the page.
| Both sides previous revision
Previous revision
|
|
automatizace:liquibase [2023/01/20 14:05]
tomas |
automatizace:liquibase [2023/01/20 14:17] (current)
tomas |
| === CMD === | === CMD === |
| ''%%java -jar liquibase.jar --driver com.mysql.jdbc.Driver --classpath=mysql-connector-java-5.1.43-bin.jar --username=USR --password=PWD --url=jdbc://localhost/lb --changeLogFile=xmlsample/changelog.xml update%%'' ... update operace nad mysql\\ | ''%%java -jar liquibase.jar --driver com.mysql.jdbc.Driver --classpath=mysql-connector-java-5.1.43-bin.jar --username=USR --password=PWD --url=jdbc://localhost/lb --changeLogFile=xmlsample/changelog.xml update%%'' ... update operace nad mysql\\ |
| ''%%java -jar liquibase.jar --driver oracle.jdbc.driver.OracleDriver --classpath=ojdbc-... --url=jdbc://...1521/xxx --changeLogFile=xmlsample/changelog.xml rollbackCount 1%%'' ... rollback operace o jeden krok nad Oracle databází\\ | ''%%java -jar liquibase.jar --driver oracle.jdbc.driver.OracleDriver --classpath=ojdbc7.jar --username=USR --password=PWD --url=jdbc:oracle:thin:@IP:1521/DB --changeLogFile=xmlsample/changelog.xml rollbackCount 1%%'' ... rollback operace o jeden krok nad Oracle databází\\ |
| | |
| | === ChangeSet format === |
| | <code> |
| | <databaseChangeLog |
| | xmlns="http://www.liquibase.org/xml/ns/dbchangelog" |
| | xmlns:xsi="http://www.wš.org/2001XMLSchemaInstance" |
| | xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" |
| | xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.wš.org/2001XMLSchemaInstance http://www.liquibase.org/xml/ns/dbchangelog-ext"> |
| | <include file="db/changeset1.xml"/> |
| | <include file="db/changeset1.xml"/> |
| | </databaseChangeLog> |
| | </code> |
| | |
| | <code> |
| | <databaseChangeLog |
| | xmlns="http://www.liquibase.org/xml/ns/dbchangelog" |
| | xmlns:xsi="http://www.wš.org/2001XMLSchemaInstance" |
| | xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" |
| | xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.wš.org/2001XMLSchemaInstance http://www.liquibase.org/xml/ns/dbchangelog-ext"> |
| | <changeSet id=0 author="tom"> |
| | <createTable tableName="tabulka1"> |
| | <column name="id" type="int"> |
| | <constrains primaryKey="true" nullable="false" /> |
| | </column> |
| | </createTable> |
| | </changeSet> |
| | </databaseChangeLog> |
| | </code> |
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3