Hi,
I have got a formatted Sql file with all the CREATE and ALTER table statements.
But some statements are in an external file. What is the syntax for sqlFile tag in Liquibase formatted sql file?
Thanks,
Nagma.
Hi,
I have got a formatted Sql file with all the CREATE and ALTER table statements.
But some statements are in an external file. What is the syntax for sqlFile tag in Liquibase formatted sql file?
Thanks,
Nagma.
There isn’t really an equivalent - you would have to use database specific techniques. I searched for “Use One SQL file from another” and found some results. For example, if you are using MSSQL, you could do this:
http://stackoverflow.com/questions/5237198/transactsql-to-run-another-transactsql-script
If using Oracle, here are some ideas:
http://stackoverflow.com/questions/24119041/run-sqlplus-script-that-runs-other-script-files
Because Liquibase executes SQL using JDBC calls rather than native tools (i.e. sqlcmd or sqlplus) you may run into difficulties with either of these techniques.
Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/