Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import liquibase.database.Database;
- import liquibase.database.DatabaseFactory;
- import liquibase.diff.DiffGeneratorFactory;
- import liquibase.diff.DiffResult;
- import liquibase.diff.compare.CompareControl;
- import liquibase.diff.output.DiffOutputControl;
- import liquibase.diff.output.changelog.DiffToChangeLog;
- import liquibase.resource.ClassLoaderResourceAccessor;
- import liquibase.resource.ResourceAccessor;
- public class DiffDatabase {
- public static void main(String[] args) throws Exception {
- String userName = "";
- String password = "";
- String driver = "net.sourceforge.jtds.jdbc.Driver";
- String dbUrl = "jdbc:jtds:sqlserver://10.1.1.1/DB";
- String refdbUrl = "jdbc:jtds:sqlserver://10.1.1.1/REFDB";
- ResourceAccessor resourceAccessor = new ClassLoaderResourceAccessor();
- Database db = DatabaseFactory.getInstance().openDatabase(dbUrl, userName, password, driver, null, null, null, resourceAccessor);
- Database refdb = DatabaseFactory.getInstance().openDatabase(refdbUrl, userName, password, driver, null, null, null, resourceAccessor);
- CompareControl compareControl = new CompareControl();
- DiffResult diffResult = DiffGeneratorFactory.getInstance().compare(refdb, db, compareControl);
- DiffOutputControl diffOutputControl = new DiffOutputControl().setIncludeCatalog(false).setIncludeSchema(false);
- new DiffToChangeLog(diffResult, diffOutputControl).print(System.out);
- }
- }
Add Comment
Please, Sign In to add comment