Home » SQL & PL/SQL » Client Tools » SQL Developer Database Diff... (Version 18.2.0.183)
SQL Developer Database Diff... [message #673796] Mon, 10 December 2018 07:18 Go to next message
wtolentino
Messages: 284
Registered: March 2005
Senior Member
database diff does this functionality in SQL Developer applies right away the difference or generates some output to see the difference of the schema from one database to another?

thanks,
warren
Re: SQL Developer Database Diff... [message #673799 is a reply to message #673796] Mon, 10 December 2018 08:03 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
wtolentino wrote on Mon, 10 December 2018 07:18
database diff does this functionality in SQL Developer applies right away the difference or generates some output to see the difference of the schema from one database to another?

thanks,
warren
Did you read the SQL Developer User's Guide? It is pretty clear on this point:

Quote:
6.91 Database Differences

This wizard is displayed if you click Tools, then Database Diff. You can find differences between objects of the same type and name (for example, tables named CUSTOMERS) accessible from two different connections, and optionally generate DDL to update the objects in the destination schema to reflect the differences in the source schema.
(emphasis mine)
From https://docs.oracle.com/en/database/oracle/sql-developer/18.3/rptug/sql-developer-dialogs.html#GUID-DA0ED7C1-B3A6-4625-B9A0-64467A525 419
Re: SQL Developer Database Diff... [message #673800 is a reply to message #673799] Mon, 10 December 2018 08:29 Go to previous messageGo to next message
wtolentino
Messages: 284
Registered: March 2005
Senior Member
thank you. yes I read it from the help. just want to be sure.

this is the part that I need a little bit of help.

"and optionally generate DDL to update the objects"


does it mean that when it generates the DDL it will also update the objects in the target database?

[Updated on: Mon, 10 December 2018 08:36]

Report message to a moderator

Re: SQL Developer Database Diff... [message #673801 is a reply to message #673800] Mon, 10 December 2018 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
wtolentino wrote on Mon, 10 December 2018 06:29
thank you. yes I read it from the help. just want to be sure.

BTW - just a reminder that you can be sure & wrong at the same time
Re: SQL Developer Database Diff... [message #673802 is a reply to message #673801] Mon, 10 December 2018 08:39 Go to previous messageGo to next message
wtolentino
Messages: 284
Registered: March 2005
Senior Member
"and optionally generate DDL to update the objects"

does that mean it will automaticaly update the objects in the target database?
Re: SQL Developer Database Diff... [message #673803 is a reply to message #673801] Mon, 10 December 2018 09:05 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
BlackSwan wrote on Mon, 10 December 2018 14:34
wtolentino wrote on Mon, 10 December 2018 06:29
thank you. yes I read it from the help. just want to be sure.

BTW - just a reminder that you can be sure & wrong at the same time
Given that OP is asking for clarification, that response makes no sense.
Re: SQL Developer Database Diff... [message #673804 is a reply to message #673802] Mon, 10 December 2018 09:07 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
wtolentino wrote on Mon, 10 December 2018 14:39
"and optionally generate DDL to update the objects"

does that mean it will automaticaly update the objects in the target database?
I would imagine that it doesn't, but I don't use SQL Developer.
PL/SQL Developer does not - it displays the DML and there's a button you can press to apply to the other DB (you can also save/copy).
I would have thought SQL Developer is the same, but like I say - can't check.

Ed, or one of the others that uses it can clarify that point.
Re: SQL Developer Database Diff... [message #673822 is a reply to message #673800] Tue, 11 December 2018 06:37 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
wtolentino wrote on Mon, 10 December 2018 08:29
thank you. yes I read it from the help. just want to be sure.

this is the part that I need a little bit of help.

"and optionally generate DDL to update the objects"


does it mean that when it generates the DDL it will also update the objects in the target database?
What does it cost you to try it and see for yourself?
Re: SQL Developer Database Diff... [message #673824 is a reply to message #673822] Tue, 11 December 2018 08:00 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
They'll probably need to set up a new DB instance to run the test against, which would probably be more time and effort than it would cost you to just answer the question.
Re: SQL Developer Database Diff... [message #673847 is a reply to message #673824] Wed, 12 December 2018 07:03 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
cookiemonster wrote on Tue, 11 December 2018 08:00
They'll probably need to set up a new DB instance to run the test against, which would probably be more time and effort than it would cost you to just answer the question.
Ok, having never used DIFF myself, I did set up a test. I couldn't find anything that suggested that it would actually execute the DDL. And there doesn't seem to be anything in the docs to suggest that it would actually execute the DDL.

And FWIW, I don' accept "I don't have a test system" as an excuse. An hour spent installing VBox and creating a vm with a personal test database is time well invested for any DBA.
https://edstevensdba.wordpress.com/2018/09/19/create-a-private-oracle-test-lab-for-free/
Re: SQL Developer Database Diff... [message #673848 is a reply to message #673847] Wed, 12 December 2018 07:32 Go to previous messageGo to next message
John Watson
Messages: 8075
Registered: January 2010
Location: Global Village
Senior Member
EdStevens wrote on Wed, 12 December 2018 13:03

<snip>

And FWIW, I don' accept "I don't have a test system" as an excuse. An hour spent installing VBox and creating a vm with a personal test database is time well invested for any DBA.
https://edstevensdba.wordpress.com/2018/09/19/create-a-private-oracle-test-lab-for-free/

I always wonder how legal that is, Ed. Clearly applying a patch would not be legal, but is even an unpatched install OK? The OTN licence states Quote:
... only for the purpose of developing, testing, prototyping, and demonstrating Your application and only as long as Your application has not been used for any data processing, business, commercial, or production purposes ...
so once you have a production system, you have to license your test and dev systems. My interpretation of the licence is that as a private individual you can certainly install the software on your own PC and do whatever you like in your personal capacity, but as an employee I am not so sure that you can install it on your work PC and do testing related to your job. To do that, perhaps your company should be buying you a Personal Oracle licence (which would also permit patching) or one should use XE.

Possibly there is a grey area: using a work PC for private business, or a private PC for work related business.
Re: SQL Developer Database Diff... [message #673947 is a reply to message #673796] Tue, 18 December 2018 12:45 Go to previous message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

it doesn't apply any changes

it generates scripts that you can then vet, test, and apply yourself to the target instance

check my blog for examples if the docs aren't clear
Previous Topic: Invalid User Name (ORA-01017)
Next Topic: UTTL_HTTP to POST CLOB request
Goto Forum:
  


Current Time: Sun Dec 08 10:48:32 CST 2019