{"repo":"gitbucket/solidbase","free":true,"listed":false,"github":"https://github.com/gitbucket/solidbase","clone":"git clone https://github.com/gitbucket/solidbase.git","description":"Generic migration tool for RDBMS and other resources based on Liquibase","language":"Java","stars":40,"topics":["java","database","migration","liquibase"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Solidbase Generic migration tool for RDBMS and other resources based on Liquibase. - Multi-database (based on Liquibase) - Multi-resource (not only RDBMS) - Multi-module (modules can have their own versions) Usage Add dependency Add following dependency into your Maven pom.xml : or for Gradle add to build.gradle : Define migration Create the Liquibase migration xml files under src/main/resources . For example: - src/main/resources/test 1.0.0.xml Define migration that migrates RDBMS using these XML files: You can also add a migration for resources other than RDBMS by implementing Migration interface. Added migrations are executed in order. Run Then, run migration as below: Differences between the current version and the latest version are applied. Background Solidbase creates a following VERSIONS table to manage versions automatically: Column name Data type Not Null :--------------- :------------- :--------- MODULE ID (PK) VARCHAR(100) Yes VERSION VARCHAR(100) Yes Solidbase uses this table to know the current version. When migration of the new version is successful, it updates the version with the new version. Migration XML migration LiquibaseMigration migrates the database by Liquibase like XML as above. XML schema is improved from Liquibase to be possible to declare column information as attributes instead of nested elements. And a default variable ${currentDateTime} is available in the XML: SQL migration SqlMigration migrates the database by native SQL. Apply RDBMS specific","default_branch":null,"files":null,"tree":[],"storefront":"/r/gitbucket","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gitbucket/solidbase/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}