Moving a table from one schema to another

General Discussion
1

We have been using Liquibase for some time and love it!


Recently we wanted to move a number of tables from one schema to another. I was hoping would make this easy, but unfortunately it does not seem to be supported.


Is there any easy way to do this in LiquiBase, or are we stuck creating new tables in the target schema, migrating data, and dropping the tables in the old schema? (Because that sounds pretty miserable.)

2

Nothing built in. However, the extension support in 2.0 (http://liquibase.org/extensions) would allow you to create your own custom change that wraps whatever SQL is needed for your database(s).


Nathan