Log or print to file SQL generated by Liquibase
This is a duplicate question, but I have not seen an answer to it, so I'd like to ask it again.
Is it possible to see / log (e.g.) create table sql with constraints and all? I mean just plain simple SQL.
I would very much appreciate an answer by someone who has her-/himself done that and been able to grab the sql statements :)
maven spring-boot liquibase
asked Nov 17 '18 at 19:08
catch22catch22
195
add a comment |
This is a duplicate question, but I have not seen an answer to it, so I'd like to ask it again.
Is it possible to see / log (e.g.) create table sql with constraints and all? I mean just plain simple SQL.
I would very much appreciate an answer by someone who has her-/himself done that and been able to grab the sql statements :)
maven spring-boot liquibase
asked Nov 17 '18 at 19:08
catch22catch22
195
add a comment |
This is a duplicate question, but I have not seen an answer to it, so I'd like to ask it again.
Is it possible to see / log (e.g.) create table sql with constraints and all? I mean just plain simple SQL.
I would very much appreciate an answer by someone who has her-/himself done that and been able to grab the sql statements :)
maven spring-boot liquibase
asked Nov 17 '18 at 19:08
catch22catch22
195
This is a duplicate question, but I have not seen an answer to it, so I'd like to ask it again.
Is it possible to see / log (e.g.) create table sql with constraints and all? I mean just plain simple SQL.
I would very much appreciate an answer by someone who has her-/himself done that and been able to grab the sql statements :)
maven spring-boot liquibase
maven spring-boot liquibase
asked Nov 17 '18 at 19:08
catch22catch22
195
asked Nov 17 '18 at 19:08
catch22catch22
195
edited Nov 17 '18 at 19:27
catch22
asked Nov 17 '18 at 19:08
catch22catch22
195
asked Nov 17 '18 at 19:08
catch22catch22
195
asked Nov 17 '18 at 19:08
catch22catch22
195
195
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This is a built-in command in liquibase. If you run the updateSQL command, liquibase will generate the SQL that it would run if you ran the update command.
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53354579%2flog-or-print-to-file-sql-generated-by-liquibase%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is a built-in command in liquibase. If you run the updateSQL command, liquibase will generate the SQL that it would run if you ran the update command.
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
add a comment |
This is a built-in command in liquibase. If you run the updateSQL command, liquibase will generate the SQL that it would run if you ran the update command.
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
add a comment |
This is a built-in command in liquibase. If you run the updateSQL command, liquibase will generate the SQL that it would run if you ran the update command.
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
This is a built-in command in liquibase. If you run the updateSQL command, liquibase will generate the SQL that it would run if you ran the update command.
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
answered Nov 19 '18 at 17:27
SteveDonieSteveDonie
5,06122631
5,06122631
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
add a comment |
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
I will try that, I noticed that in the documentation of Liquibase there is an examle of that, that uses java -jar ... I tried updateSql command with maven plugin, but it did not output SQL.
– catch22
Nov 20 '18 at 11:19
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
Here are the docs for updateSql in the maven plugin. liquibase.org/documentation/maven/generated/updateSQL-mojo.html It appears that the default is to write the output to a file: Default value is: ${project.build.directory}/liquibase/migrate.sql.
– SteveDonie
Nov 21 '18 at 13:36
1
1
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
I kind of expected Liquibase to be able to figure out about drivers and changelog files just “by itself”, somehow from Spring Boot project. After adding mvn plugin config properties for driver and changelog file, Liquibase writes all SQL to file. (Thanks for help !)
– catch22
Dec 4 '18 at 11:32
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53354579%2flog-or-print-to-file-sql-generated-by-liquibase%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
