http://www.liquibase.org/ 2008-05-16T03:05:14-07:00 http://www.liquibase.org/ http://www.liquibase.org/lib/images/favicon.ico text/html 2008-05-13T01:57:24-07:00 http://www.liquibase.org/ide/home?rev=1210669044&do=diff LiquiBase is designed with the idea of building an visual tool on top of it to make managing database changes even easier. We have begun work on an Eclipse plug-in as well as a stand-alone IDE for non-Eclipse users. It is currently alpha-quality, but is under heavy development and does not support all the features planned for the final 1.0 release. Currently, it allows you to apply refactorings to your database as well as update your database from an existing change log file. Future features i… text/html 2008-05-12T11:47:09-07:00 http://www.liquibase.org/quickstart?rev=1210618029&do=diff Step 1: Create a Changelog File: The database changelog file is where all database changes are listed. It is XML based, so start with an empty XML file: <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.6" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.6 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.6.xsd"> </databaseChangeLog> text/html 2008-05-07T09:53:20-07:00 Yasuo HONDA http://www.liquibase.org/ja/manual/command_line?rev=1210179200&do=diff LiquiBase は、下記のように実行することで、コマンドラインから実行できます。 liquibase [オプション] [コマンド] (または、liquibase コマンドをjava -jar <liquibase-jar へのパス> で置き換えることもできます)。コマンドライン migrator は、必要に応じて移行したいが、Ant や Maven などがサーバーにない場合に適しています。 コマンドライン migrator は、 サーブレットリスナー, Ant, ま�… text/html 2008-05-03T08:09:18-07:00 Yasuo HONDA http://www.liquibase.org/ja/manual/update?rev=1209827358&do=diff LiquiBase によって、あなたとほかの開発者が変更ログファイルに追加した変更をデータベースに適用できます。 どのように変更セットが記録されるか それぞれの 変更セット は、”id” と “author” 属性を持っており、変更ログファイルのディレクトリとファイル名とあわせて、一意に決められます。 text/html 2008-04-30T11:27:49-07:00 http://www.liquibase.org/manual/include?rev=1209580069&do=diff The include tag allows you to break up your change-logs into more manageable pieces. <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.1 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.1.xsd"> <include file="com/example/news/news.changelog.xml"/> <include file="com/example/direct… text/html 2008-04-30T02:48:20-07:00 http://www.liquibase.org/manual/update?rev=1209548900&do=diff LiquiBase allows you to apply database changes you and other developers have added to the change log file. How Change Set Statuses are Tracked Each change set has an “id” and “author” attribute which, along with the directory and file name of the the change log file, uniquely identifies it. text/html 2008-04-29T06:31:30-07:00 Yasuo HONDA http://www.liquibase.org/ja/manual/generating_changelogs?rev=1209475890&do=diff LiquiBase をすでに存在するデータベースに対して使い始めるときは、現在のデータベーススキーマを作成する変更ログを作成するのが、とくにテストなどの目的でも、有効です。LiquiBase は、”generateChangeLog” コマンドライン コマンドを利用します。 text/html 2008-04-28T08:22:56-07:00 http://www.liquibase.org/manual/generating_changelogs?rev=1209396176&do=diff When starting to use LiquiBase on an existing database, it is often useful, particularly for testing, to have a way to generate the change log to create the current database schema. LiquiBase allows you to do this with the “generateChangeLog” command line command. text/html 2008-04-23T18:29:41-07:00 Yasuo HONDA http://www.liquibase.org/ja/download?rev=1209000581&do=diff LiquiBase Core のダウンロード 現在の LiquiBase Core のバージョンは、1.6.1 です。 SourceForge から LiquiBase Core のダウンロード アップグレード * 1.5 から 1.6 で、チェックサムの生成方法が変更されました。”liquibase clearCheckSums” または “UPDATE DATABASECHANGELOG SET MD5SUM=NULL” を実行するまで、md5sum エラーメッセージが表示されるでしょう。 * 1.4 から 1.5 で実施された変更により… text/html 2008-04-23T13:02:51-07:00 Nathan Voxland http://www.liquibase.org/download?rev=1208980971&do=diff LiquiBase Core The current version of the LiquiBase Core is 1.6.1. Download LiquiBase Core from SourceForge Upgrade Notes * 1.5 -> 1.6 introduced a change to how change set checksum generation is performed. You will get an md5sum error message until you either run “liquibase clearCheckSums” or “UPDATE DATABASECHANGELOG SET MD5SUM=NULL” * 1.4 -> 1.5 introduced changes that may break existing configurations. See the 1.5 release announcement for more information text/html 2008-04-14T10:27:41-07:00 http://www.liquibase.org/manual/command_line?rev=1208194061&do=diff LiquiBase can be run from the command line by running liquibase [options] [command] (optionally, replace the liquibase command with java -jar <path-to-liquibase-jar>). The command line migrator works well when you want to do migrations on demand, but don't have Ant or Maven available such as on servers. The command line migrator also gives you more control over the process than the Servlet Listener, Ant, or Maven do, allowing you to run maintenance commands like outputting SQL and listing/releas… text/html 2008-04-09T05:11:28-07:00 Yasuo HONDA http://www.liquibase.org/ja/manual/hibernate?rev=1207743088&do=diff LiquiBase-Hibernate は、Hibernate の”hbm2ddl“機能を代替します。 hbm2ddl と一緒に LiquiBase を利用する利点 hbm2ddl は一般的にはうまく動作しますが、基本的にはデータベースの差分(diff) ツールで、データベース差分ツールに関連する問題点があります。 text/html 2008-04-08T11:45:08-07:00 Nathan Voxland http://www.liquibase.org/manual/hibernate?rev=1207680308&do=diff The LiquiBase-Hibernate is a replacement to Hibernate's ”hbm2ddl” functionality. Advantages of LiquiBase over hbm2ddl While hbm2ddl works in general, it is basically a database diff tool and therefore has all the problems associated with database diff tools.