Mixing
Database Migration with the flyway or dbup(.net library/dbup extension) with PostgreSQL
First of all, I am sorry because it might be a stupid question but after a day research I am confused and I have a very less time to decide.
We are using TFS as a CI tool and as an SCM. And Postgresql for DB.
Planning to Automate DB with Postgresql and TFS.
Please suggest a tool for this that I can go forward with running my SQL files on specific DB as I want.
Can anyone please tell me if I use DbUp Migration Extension of TFS is it supporting Postgresql? As this link shows it only works with Microsoft SQL Server or Microsoft SQL Azure and then another Document says DbUp supports a number of different databases including Postgresql.
also, Does Flyway have support for c# and TFS ?
database postgresql flyway sql-scripts dbup
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
add a comment |
First of all, I am sorry because it might be a stupid question but after a day research I am confused and I have a very less time to decide.
We are using TFS as a CI tool and as an SCM. And Postgresql for DB.
Planning to Automate DB with Postgresql and TFS.
Please suggest a tool for this that I can go forward with running my SQL files on specific DB as I want.
Can anyone please tell me if I use DbUp Migration Extension of TFS is it supporting Postgresql? As this link shows it only works with Microsoft SQL Server or Microsoft SQL Azure and then another Document says DbUp supports a number of different databases including Postgresql.
also, Does Flyway have support for c# and TFS ?
database postgresql flyway sql-scripts dbup
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
1
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21
add a comment |
First of all, I am sorry because it might be a stupid question but after a day research I am confused and I have a very less time to decide.
We are using TFS as a CI tool and as an SCM. And Postgresql for DB.
Planning to Automate DB with Postgresql and TFS.
Please suggest a tool for this that I can go forward with running my SQL files on specific DB as I want.
Can anyone please tell me if I use DbUp Migration Extension of TFS is it supporting Postgresql? As this link shows it only works with Microsoft SQL Server or Microsoft SQL Azure and then another Document says DbUp supports a number of different databases including Postgresql.
also, Does Flyway have support for c# and TFS ?
database postgresql flyway sql-scripts dbup
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
First of all, I am sorry because it might be a stupid question but after a day research I am confused and I have a very less time to decide.
We are using TFS as a CI tool and as an SCM. And Postgresql for DB.
Planning to Automate DB with Postgresql and TFS.
Please suggest a tool for this that I can go forward with running my SQL files on specific DB as I want.
Can anyone please tell me if I use DbUp Migration Extension of TFS is it supporting Postgresql? As this link shows it only works with Microsoft SQL Server or Microsoft SQL Azure and then another Document says DbUp supports a number of different databases including Postgresql.
also, Does Flyway have support for c# and TFS ?
database postgresql flyway sql-scripts dbup
database postgresql flyway sql-scripts dbup
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
edited Nov 20 '18 at 9:55
Darshana Patel
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
asked Nov 20 '18 at 5:48
Darshana PatelDarshana Patel
438
438
1
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21
add a comment |
1
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21
1
1
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21
add a comment |
1 Answer
1
active
oldest
votes
Most popular tools to do what you want is Liquibase and Flyway.
As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommendLiquidbaseif you want something based on abstraction to increase portability.
– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
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%2f53386953%2fdatabase-migration-with-the-flyway-or-dbup-net-library-dbup-extension-with-pos%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
Most popular tools to do what you want is Liquibase and Flyway.
As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommendLiquidbaseif you want something based on abstraction to increase portability.
– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
add a comment |
Most popular tools to do what you want is Liquibase and Flyway.
As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommendLiquidbaseif you want something based on abstraction to increase portability.
– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
add a comment |
Most popular tools to do what you want is Liquibase and Flyway.
As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
Most popular tools to do what you want is Liquibase and Flyway.
As I know there is only one significant difference: Flyway - plain SQL based, Liquibase - provides abstraction level based on XML, JSON or YAML as well as plain SQL. You can use abstractions (provided by Liquibase) to increase portability of your scripts.
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
edited Nov 20 '18 at 8:33
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
answered Nov 20 '18 at 8:14
Mikita KaraliouMikita Karaliou
162
162
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommendLiquidbaseif you want something based on abstraction to increase portability.
– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
add a comment |
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommendLiquidbaseif you want something based on abstraction to increase portability.
– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
1
1
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
Liquibase supports plain SQL scripts as well. Although I prefer Liquibase especially because of the DBMS independent XML format.
– a_horse_with_no_name
Nov 20 '18 at 8:16
@a_horse_with_no_name This is what I wanted to say. I would recommend
Liquidbase if you want something based on abstraction to increase portability.– Mikita Karaliou
Nov 20 '18 at 8:24
@a_horse_with_no_name This is what I wanted to say. I would recommend
Liquidbase if you want something based on abstraction to increase portability.– Mikita Karaliou
Nov 20 '18 at 8:24
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
But "the principal difference" isn't a difference as Liquibase supports plain SQL scripts as well. If you want to point out a difference then it's that Liquibase supports plain SQL scripts as Flyway does plus DBMS independent alternatives
– a_horse_with_no_name
Nov 20 '18 at 8:27
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
@a_horse_with_no_name does it better now?
– Mikita Karaliou
Nov 20 '18 at 8:33
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%2f53386953%2fdatabase-migration-with-the-flyway-or-dbup-net-library-dbup-extension-with-pos%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
We use liquibase.org
– a_horse_with_no_name
Nov 20 '18 at 6:44
Possible duplicate of Database sync or migration tool
– Basil Bourque
Nov 20 '18 at 8:17
Asking for tools is off-topic on Stack Overflow. Likely asked and answered already on the sister site Software Recommendations Stack Exchange. Tip: “database migration” is the emerging term for what you seem to be asking. See also Wikipedia.
– Basil Bourque
Nov 20 '18 at 8:21