migration of Oracle 11g database to Google Cloud Spanner
We are planning to Migrate our Oracle 11g database to Google Cloud spanner, and I want to confirm that it is possible or not.
We need to plan migration steps, what are the risks and possible troubles during migration.
Need opinion from experts regarding said migration, I have done much googling but still need recommendations for migration to cloud spanner.
google-cloud-platform cloud oracle11gr2 google-cloud-spanner
edited Dec 14 '18 at 9:34
Maxim
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
add a comment |
We are planning to Migrate our Oracle 11g database to Google Cloud spanner, and I want to confirm that it is possible or not.
We need to plan migration steps, what are the risks and possible troubles during migration.
Need opinion from experts regarding said migration, I have done much googling but still need recommendations for migration to cloud spanner.
google-cloud-platform cloud oracle11gr2 google-cloud-spanner
edited Dec 14 '18 at 9:34
Maxim
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
add a comment |
We are planning to Migrate our Oracle 11g database to Google Cloud spanner, and I want to confirm that it is possible or not.
We need to plan migration steps, what are the risks and possible troubles during migration.
Need opinion from experts regarding said migration, I have done much googling but still need recommendations for migration to cloud spanner.
google-cloud-platform cloud oracle11gr2 google-cloud-spanner
edited Dec 14 '18 at 9:34
Maxim
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
We are planning to Migrate our Oracle 11g database to Google Cloud spanner, and I want to confirm that it is possible or not.
We need to plan migration steps, what are the risks and possible troubles during migration.
Need opinion from experts regarding said migration, I have done much googling but still need recommendations for migration to cloud spanner.
google-cloud-platform cloud oracle11gr2 google-cloud-spanner
google-cloud-platform cloud oracle11gr2 google-cloud-spanner
edited Dec 14 '18 at 9:34
Maxim
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
edited Dec 14 '18 at 9:34
Maxim
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
edited Dec 14 '18 at 9:34
Maxim
1,553211
edited Dec 14 '18 at 9:34
Maxim
1,553211
edited Dec 14 '18 at 9:34
Maxim
1,553211
1,553211
asked Nov 15 '18 at 15:40
user10266688user10266688
127
asked Nov 15 '18 at 15:40
user10266688user10266688
127
asked Nov 15 '18 at 15:40
user10266688user10266688
127
127
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Anything is possible if you have enough resources and time!
The relative complexity depends on your application, notably how much of your Oracle DB's features you are using, because Cloud Spanner is not feature-equivalent to Oracle (or for that matter to many other DB's).
If you are using it as a simple transactional datastore, then it would be relatively easy. If you have triggers, stored procedures, queues, per-user/per-table ACLs, on-delete clauses then you are going to have a lot of extra work.
To have an idea of the work involved, you can watch at a Cloud Next #18 talk where migration to Cloud Spanner from both RDBMS and NoSQL DBs are discussed in general terms.
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
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%2f53322956%2fmigration-of-oracle-11g-database-to-google-cloud-spanner%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
Anything is possible if you have enough resources and time!
The relative complexity depends on your application, notably how much of your Oracle DB's features you are using, because Cloud Spanner is not feature-equivalent to Oracle (or for that matter to many other DB's).
If you are using it as a simple transactional datastore, then it would be relatively easy. If you have triggers, stored procedures, queues, per-user/per-table ACLs, on-delete clauses then you are going to have a lot of extra work.
To have an idea of the work involved, you can watch at a Cloud Next #18 talk where migration to Cloud Spanner from both RDBMS and NoSQL DBs are discussed in general terms.
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
add a comment |
Anything is possible if you have enough resources and time!
The relative complexity depends on your application, notably how much of your Oracle DB's features you are using, because Cloud Spanner is not feature-equivalent to Oracle (or for that matter to many other DB's).
If you are using it as a simple transactional datastore, then it would be relatively easy. If you have triggers, stored procedures, queues, per-user/per-table ACLs, on-delete clauses then you are going to have a lot of extra work.
To have an idea of the work involved, you can watch at a Cloud Next #18 talk where migration to Cloud Spanner from both RDBMS and NoSQL DBs are discussed in general terms.
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
add a comment |
Anything is possible if you have enough resources and time!
The relative complexity depends on your application, notably how much of your Oracle DB's features you are using, because Cloud Spanner is not feature-equivalent to Oracle (or for that matter to many other DB's).
If you are using it as a simple transactional datastore, then it would be relatively easy. If you have triggers, stored procedures, queues, per-user/per-table ACLs, on-delete clauses then you are going to have a lot of extra work.
To have an idea of the work involved, you can watch at a Cloud Next #18 talk where migration to Cloud Spanner from both RDBMS and NoSQL DBs are discussed in general terms.
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
Anything is possible if you have enough resources and time!
The relative complexity depends on your application, notably how much of your Oracle DB's features you are using, because Cloud Spanner is not feature-equivalent to Oracle (or for that matter to many other DB's).
If you are using it as a simple transactional datastore, then it would be relatively easy. If you have triggers, stored procedures, queues, per-user/per-table ACLs, on-delete clauses then you are going to have a lot of extra work.
To have an idea of the work involved, you can watch at a Cloud Next #18 talk where migration to Cloud Spanner from both RDBMS and NoSQL DBs are discussed in general terms.
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
answered Dec 7 '18 at 15:42
RedPandaCuriosRedPandaCurios
1,561817
1,561817
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
add a comment |
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
1
1
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
Thanks for your time
– user10266688
Dec 7 '18 at 16:08
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%2f53322956%2fmigration-of-oracle-11g-database-to-google-cloud-spanner%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
