Oracle SQL Developer database diff doesn’t list my connections












0















I’m trying to perform a Diff on two DB2 schema’s and when I try to select my source and destination connections it doesn’t list my NEW connection. I’m using latest version. I can connect to DB2 manually and query as well, but just can’t sect that connection during database Diff.



Where are the connections saved in sql
Developer?










share|improve this question

























  • Diff on non-oracle is not supported.

    – Kris Rice
    Nov 15 '18 at 16:42
















0















I’m trying to perform a Diff on two DB2 schema’s and when I try to select my source and destination connections it doesn’t list my NEW connection. I’m using latest version. I can connect to DB2 manually and query as well, but just can’t sect that connection during database Diff.



Where are the connections saved in sql
Developer?










share|improve this question

























  • Diff on non-oracle is not supported.

    – Kris Rice
    Nov 15 '18 at 16:42














0












0








0








I’m trying to perform a Diff on two DB2 schema’s and when I try to select my source and destination connections it doesn’t list my NEW connection. I’m using latest version. I can connect to DB2 manually and query as well, but just can’t sect that connection during database Diff.



Where are the connections saved in sql
Developer?










share|improve this question
















I’m trying to perform a Diff on two DB2 schema’s and when I try to select my source and destination connections it doesn’t list my NEW connection. I’m using latest version. I can connect to DB2 manually and query as well, but just can’t sect that connection during database Diff.



Where are the connections saved in sql
Developer?







db2 oracle-sqldeveloper






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 15 '18 at 17:01









a_horse_with_no_name

295k46451546




295k46451546










asked Nov 15 '18 at 15:33









sunny babausunny babau

116




116













  • Diff on non-oracle is not supported.

    – Kris Rice
    Nov 15 '18 at 16:42



















  • Diff on non-oracle is not supported.

    – Kris Rice
    Nov 15 '18 at 16:42

















Diff on non-oracle is not supported.

– Kris Rice
Nov 15 '18 at 16:42





Diff on non-oracle is not supported.

– Kris Rice
Nov 15 '18 at 16:42












1 Answer
1






active

oldest

votes


















0














That feature is reserved for Oracle Database connections.



DB2 connectivity is provided for migrations to Oracle only.



We have limited support for DB2 in the Data Modeler (which is part of SQL Developer), and you can compare models, but the generation of DDL synch scripts is reserved for Oracle data models only.



enter image description here






share|improve this answer
























  • Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

    – sunny babau
    Nov 15 '18 at 17:24











  • there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

    – thatjeffsmith
    Nov 15 '18 at 19:29











  • Try IBM Data Studio

    – Paul Vernon
    Nov 15 '18 at 23:01











  • Is IBM Data Studio free? Any other free tools with good GUI?

    – sunny babau
    Nov 16 '18 at 1:31











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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53322809%2foracle-sql-developer-database-diff-doesn-t-list-my-connections%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









0














That feature is reserved for Oracle Database connections.



DB2 connectivity is provided for migrations to Oracle only.



We have limited support for DB2 in the Data Modeler (which is part of SQL Developer), and you can compare models, but the generation of DDL synch scripts is reserved for Oracle data models only.



enter image description here






share|improve this answer
























  • Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

    – sunny babau
    Nov 15 '18 at 17:24











  • there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

    – thatjeffsmith
    Nov 15 '18 at 19:29











  • Try IBM Data Studio

    – Paul Vernon
    Nov 15 '18 at 23:01











  • Is IBM Data Studio free? Any other free tools with good GUI?

    – sunny babau
    Nov 16 '18 at 1:31
















0














That feature is reserved for Oracle Database connections.



DB2 connectivity is provided for migrations to Oracle only.



We have limited support for DB2 in the Data Modeler (which is part of SQL Developer), and you can compare models, but the generation of DDL synch scripts is reserved for Oracle data models only.



enter image description here






share|improve this answer
























  • Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

    – sunny babau
    Nov 15 '18 at 17:24











  • there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

    – thatjeffsmith
    Nov 15 '18 at 19:29











  • Try IBM Data Studio

    – Paul Vernon
    Nov 15 '18 at 23:01











  • Is IBM Data Studio free? Any other free tools with good GUI?

    – sunny babau
    Nov 16 '18 at 1:31














0












0








0







That feature is reserved for Oracle Database connections.



DB2 connectivity is provided for migrations to Oracle only.



We have limited support for DB2 in the Data Modeler (which is part of SQL Developer), and you can compare models, but the generation of DDL synch scripts is reserved for Oracle data models only.



enter image description here






share|improve this answer













That feature is reserved for Oracle Database connections.



DB2 connectivity is provided for migrations to Oracle only.



We have limited support for DB2 in the Data Modeler (which is part of SQL Developer), and you can compare models, but the generation of DDL synch scripts is reserved for Oracle data models only.



enter image description here







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 15 '18 at 17:00









thatjeffsmiththatjeffsmith

7,67711340




7,67711340













  • Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

    – sunny babau
    Nov 15 '18 at 17:24











  • there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

    – thatjeffsmith
    Nov 15 '18 at 19:29











  • Try IBM Data Studio

    – Paul Vernon
    Nov 15 '18 at 23:01











  • Is IBM Data Studio free? Any other free tools with good GUI?

    – sunny babau
    Nov 16 '18 at 1:31



















  • Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

    – sunny babau
    Nov 15 '18 at 17:24











  • there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

    – thatjeffsmith
    Nov 15 '18 at 19:29











  • Try IBM Data Studio

    – Paul Vernon
    Nov 15 '18 at 23:01











  • Is IBM Data Studio free? Any other free tools with good GUI?

    – sunny babau
    Nov 16 '18 at 1:31

















Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

– sunny babau
Nov 15 '18 at 17:24





Any other tools that can do on DB2. Please I periodically get new changes and I need to generate Delata script and move it to higher environments

– sunny babau
Nov 15 '18 at 17:24













there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

– thatjeffsmith
Nov 15 '18 at 19:29





there are lots of tools out there, most of them that do what you want, will cost $ - so make sure IBM doesn't offer something first

– thatjeffsmith
Nov 15 '18 at 19:29













Try IBM Data Studio

– Paul Vernon
Nov 15 '18 at 23:01





Try IBM Data Studio

– Paul Vernon
Nov 15 '18 at 23:01













Is IBM Data Studio free? Any other free tools with good GUI?

– sunny babau
Nov 16 '18 at 1:31





Is IBM Data Studio free? Any other free tools with good GUI?

– sunny babau
Nov 16 '18 at 1:31


















draft saved

draft discarded




















































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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53322809%2foracle-sql-developer-database-diff-doesn-t-list-my-connections%23new-answer', 'question_page');
}
);

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







這個網誌中的熱門文章

Xamarin.form Move up view when keyboard appear

Post-Redirect-Get with Spring WebFlux and Thymeleaf

Anylogic : not able to use stopDelay()