Compare two schema's in MySQL and detect compatibility
My use case is to take data from one version of MySQL schema and put it in another. So even before putting the data, I want to check if the schema of the source is compatible with destination. For examples, if the new column is added in the destination and which is nullable, then they are still compatible, where as dropping a column is not compatible change since source now has extra column and destination doesn't and will break import of data.
mysql database database-schema compatibility
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
add a comment |
My use case is to take data from one version of MySQL schema and put it in another. So even before putting the data, I want to check if the schema of the source is compatible with destination. For examples, if the new column is added in the destination and which is nullable, then they are still compatible, where as dropping a column is not compatible change since source now has extra column and destination doesn't and will break import of data.
mysql database database-schema compatibility
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36
add a comment |
My use case is to take data from one version of MySQL schema and put it in another. So even before putting the data, I want to check if the schema of the source is compatible with destination. For examples, if the new column is added in the destination and which is nullable, then they are still compatible, where as dropping a column is not compatible change since source now has extra column and destination doesn't and will break import of data.
mysql database database-schema compatibility
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
My use case is to take data from one version of MySQL schema and put it in another. So even before putting the data, I want to check if the schema of the source is compatible with destination. For examples, if the new column is added in the destination and which is nullable, then they are still compatible, where as dropping a column is not compatible change since source now has extra column and destination doesn't and will break import of data.
mysql database database-schema compatibility
mysql database database-schema compatibility
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
asked Dec 22 '18 at 2:39
WarewolfWarewolf
23
23
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36
add a comment |
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36
add a comment |
1 Answer
1
active
oldest
votes
to compare the schema of two MySQL databases I suggest to use:
TiCodeX SQL Schema Compare (https://www.ticodex.com).
It also gives you the migration script to update the destination database in case there are differences.
It's a very cheap but professional tool and with the same license you can use it also for MicrosoftSQL and PostgreSQL databases.
It's worth to mention that is the only tool I've found that also works nicely on Linux and MacOS.
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
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%2f53892651%2fcompare-two-schemas-in-mysql-and-detect-compatibility%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
to compare the schema of two MySQL databases I suggest to use:
TiCodeX SQL Schema Compare (https://www.ticodex.com).
It also gives you the migration script to update the destination database in case there are differences.
It's a very cheap but professional tool and with the same license you can use it also for MicrosoftSQL and PostgreSQL databases.
It's worth to mention that is the only tool I've found that also works nicely on Linux and MacOS.
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
add a comment |
to compare the schema of two MySQL databases I suggest to use:
TiCodeX SQL Schema Compare (https://www.ticodex.com).
It also gives you the migration script to update the destination database in case there are differences.
It's a very cheap but professional tool and with the same license you can use it also for MicrosoftSQL and PostgreSQL databases.
It's worth to mention that is the only tool I've found that also works nicely on Linux and MacOS.
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
add a comment |
to compare the schema of two MySQL databases I suggest to use:
TiCodeX SQL Schema Compare (https://www.ticodex.com).
It also gives you the migration script to update the destination database in case there are differences.
It's a very cheap but professional tool and with the same license you can use it also for MicrosoftSQL and PostgreSQL databases.
It's worth to mention that is the only tool I've found that also works nicely on Linux and MacOS.
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
to compare the schema of two MySQL databases I suggest to use:
TiCodeX SQL Schema Compare (https://www.ticodex.com).
It also gives you the migration script to update the destination database in case there are differences.
It's a very cheap but professional tool and with the same license you can use it also for MicrosoftSQL and PostgreSQL databases.
It's worth to mention that is the only tool I've found that also works nicely on Linux and MacOS.
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
answered Dec 28 '18 at 14:07
Daniele DebernardiDaniele Debernardi
212
212
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%2f53892651%2fcompare-two-schemas-in-mysql-and-detect-compatibility%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
This is not clear. What is your question? What have you tried? How are you stuck? Why bother to check first?
– philipxy
Dec 22 '18 at 4:04
The question is to compare whether two schemas are compatible in the sense, whether data from one can be inserted into another without error. I have tried of options like string parsing but it's getting complicated. We want to throw error ahead since customer will not understand sql insertion errors
– Warewolf
Dec 22 '18 at 4:08
Please clarify via post edits, not comments. PS This is too broad & you have shown no effort. Also there are many similar validation/migration questions already you can google with site:stackoverflow.com or site:dba.stackexchange.com. Please see How to Ask & other help center links and ask a specific question about being stuck in the context of research & work you have done.
– philipxy
Dec 22 '18 at 5:36