Is there a way to convert sql queries to liquibase changelog format?
I would like to know if it is possible to convert an existing sql script into xml format of changelogs of a liquibase?
Thanks in advance.
java sql spring-data-jpa liquibase liquibase-hibernate
asked Nov 12 '18 at 16:21
BelhamBelham
308
add a comment |
I would like to know if it is possible to convert an existing sql script into xml format of changelogs of a liquibase?
Thanks in advance.
java sql spring-data-jpa liquibase liquibase-hibernate
asked Nov 12 '18 at 16:21
BelhamBelham
308
1
You can use the<sql>tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator
– Ivan Kaloyanov
Nov 12 '18 at 16:37
add a comment |
I would like to know if it is possible to convert an existing sql script into xml format of changelogs of a liquibase?
Thanks in advance.
java sql spring-data-jpa liquibase liquibase-hibernate
asked Nov 12 '18 at 16:21
BelhamBelham
308
I would like to know if it is possible to convert an existing sql script into xml format of changelogs of a liquibase?
Thanks in advance.
java sql spring-data-jpa liquibase liquibase-hibernate
java sql spring-data-jpa liquibase liquibase-hibernate
asked Nov 12 '18 at 16:21
BelhamBelham
308
asked Nov 12 '18 at 16:21
BelhamBelham
308
asked Nov 12 '18 at 16:21
BelhamBelham
308
asked Nov 12 '18 at 16:21
BelhamBelham
308
asked Nov 12 '18 at 16:21
BelhamBelham
308
308
1
You can use the<sql>tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator
– Ivan Kaloyanov
Nov 12 '18 at 16:37
add a comment |
1
You can use the<sql>tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator
– Ivan Kaloyanov
Nov 12 '18 at 16:37
1
1
You can use the
<sql> tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator– Ivan Kaloyanov
Nov 12 '18 at 16:37
You can use the
<sql> tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator– Ivan Kaloyanov
Nov 12 '18 at 16:37
add a comment |
1 Answer
1
active
oldest
votes
You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.
answered Nov 13 '18 at 7:54
JensJens
4,20313258
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%2f53266206%2fis-there-a-way-to-convert-sql-queries-to-liquibase-changelog-format%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
You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.
answered Nov 13 '18 at 7:54
JensJens
4,20313258
add a comment |
You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.
answered Nov 13 '18 at 7:54
JensJens
4,20313258
add a comment |
You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.
answered Nov 13 '18 at 7:54
JensJens
4,20313258
You could use a detour via a database. Apply your script to a database of choice (that is supported by liquibase). Then use generateChangeLog to generate the changelogs in xml from the database.
answered Nov 13 '18 at 7:54
JensJens
4,20313258
answered Nov 13 '18 at 7:54
JensJens
4,20313258
answered Nov 13 '18 at 7:54
JensJens
4,20313258
answered Nov 13 '18 at 7:54
JensJens
4,20313258
4,20313258
add a comment |
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%2f53266206%2fis-there-a-way-to-convert-sql-queries-to-liquibase-changelog-format%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
1
You can use the
<sql>tag and run your "SQL script" that way inside your liquid base changelog. Otherwise I don't know about any tools to convert plain SQL into changelog XML file. I also suggest you to taka a look at stackoverflow.com/questions/17063169/liquibase-xml-generator– Ivan Kaloyanov
Nov 12 '18 at 16:37