i'm trying liquibase diff in oracle using ant script.
here's snippet preforms diff
<target name="diff-database"> <diffdatabasetochangelog driver=${db.driver}" url="${db.url}" username="${db.username}" password="${db.password}" referenceurl="jdbc:oracle:thin@hostname:port:sid" referenceusername="user1" referencepassword="password1" outputfile="changelog.xml" classpathref="tools.class.path" </diffdatabasetochangelog> </target>
here's issue.
- the 2 databases need compare both oracle.
- for referencedb need access tables under user, call user2, login user2 disabled on server need run from.
- luckily have access referencedb under user, call user1, , user has privilege "select table". should able access tables user2 user1.
so given of information, how specify want use user2's tables reference db?
i've @ this page, haven't found solves problem.
it should referencedefaultschemaname parameter (http://www.liquibase.org/documentation/maven/maven_diff.html), according https://liquibase.jira.com/browse/core-2364 there issues (i've not triedit myself).
Comments
Post a Comment