SQL Developer Database Diff... [message #673796] |
Mon, 10 December 2018 07:18 |
wtolentino
Messages: 404 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 #673803 is a reply to message #673801] |
Mon, 10 December 2018 09:05 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
BlackSwan wrote on Mon, 10 December 2018 14:34wtolentino wrote on Mon, 10 December 2018 06:29thank 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 |
cookiemonster
Messages: 13925 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 #673848 is a reply to message #673847] |
Wed, 12 December 2018 07:32 |
John Watson
Messages: 8938 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.
|
|
|
|