parvu.org
Open in
urlscan Pro
192.0.78.142
Public Scan
URL:
https://parvu.org/2022/03/15/tuesday-post-database-compare/
Submission: On March 15 via api from DE — Scanned from DE
Submission: On March 15 via api from DE — Scanned from DE
Form analysis 3 forms found in the DOM
GET https://parvu.org/
<form id="header-searchform" class="header-searchform has-border-radius th-bg-white" method="get" action="https://parvu.org/" role="search">
<label for="header-search-input" class="th-w-full th-mb-0">
<span class="screen-reader-text">Search for:</span>
<input type="text" id="header-search-input" class="field th-text-secondary-base th-w-full" placeholder="Search..." name="s" value="">
</label>
<button type="submit" class="submit has-border-radius clean-button th-flex th-ml-2xs">
<svg class="svg-icon th-fill-current" width="24" height="24" aria-hidden="true" role="img" focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round"
stroke-linejoin="round">
<circle cx="11" cy="11" r="8"></circle>
<line x1="21" y1="21" x2="16.65" y2="16.65"></line>
</svg> <span class="screen-reader-text">Search</span>
</button>
</form>GET https://parvu.org
<form action="https://parvu.org" method="get"><label class="screen-reader-text" for="cat">Categories</label><select name="cat" id="cat" class="postform">
<option value="-1">Select Category</option>
<option class="level-0" value="278">Lifestyle (12)</option>
<option class="level-1" value="1677"> Nutrition (3)</option>
<option class="level-1" value="1675"> Running (10)</option>
<option class="level-0" value="119437220">Scripts (2)</option>
<option class="level-0" value="119437219">tech (34)</option>
<option class="level-1" value="291"> Apple (7)</option>
<option class="level-2" value="3348"> Mac OS X (5)</option>
<option class="level-1" value="119437208"> db (26)</option>
<option class="level-2" value="3766"> Oracle (25)</option>
<option class="level-3" value="536424"> 11g (1)</option>
<option class="level-3" value="951292"> 12c (2)</option>
<option class="level-3" value="1736634"> 19c (3)</option>
<option class="level-3" value="1073593"> Autonomous (9)</option>
<option class="level-3" value="122141"> OCI (2)</option>
<option class="level-3" value="751749"> SQL Developer (6)</option>
<option class="level-3" value="119437198"> Undocumented (1)</option>
<option class="level-3" value="119437197"> Unjustly Ignored (2)</option>
<option class="level-1" value="119437215"> SPOUG (1)</option>
<option class="level-1" value="9203"> Unix (4)</option>
<option class="level-2" value="3588"> FreeBSD (1)</option>
<option class="level-2" value="610"> Linux (2)</option>
<option class="level-3" value="905826"> OEL (1)</option>
<option class="level-0" value="1">Uncategorized (4)</option>
<option class="level-0" value="1857">World (15)</option>
</select>
</form>POST /2022/03/15/tuesday-post-database-compare/
<form action="/2022/03/15/tuesday-post-database-compare/" method="post">
<label for="target_email">Send to Email Address</label>
<input type="email" name="target_email" id="target_email" value="">
<label for="source_name">Your Name</label>
<input type="text" name="source_name" id="source_name" value="">
<label for="source_email">Your Email Address</label>
<input type="email" name="source_email" id="source_email" value="">
<input type="text" id="jetpack-source_f_name" name="source_f_name" class="input" value="" size="25" autocomplete="off" title="This field is for validation and should not be changed">
<img style="float: right; display: none" class="loading" src="https://parvu.org/wp-content/plugins/jetpack/modules/sharedaddy/images/loading.gif" alt="loading" width="16" height="16">
<input type="submit" value="Send Email" class="sharing_send">
<a rel="nofollow" href="#cancel" class="sharing_cancel" role="button">Cancel</a>
<div class="errors errors-1" style="display: none;"> Post was not sent - check your email addresses! </div>
<div class="errors errors-2" style="display: none;"> Email check failed, please try again </div>
<div class="errors errors-3" style="display: none;"> Sorry, your blog cannot share posts by email. </div>
</form>Text Content
Skip to content
* Scripts
* Photos
* Finland Summer 2020
* About Me
* My Public Appearances
* På svenska
* Lätta Bladet
* 8 SIDOR
* Rivstart A1+A2
* Svenska Akademiens ordlista
* În Română
* Linkedin
* Twitter
* Instagram
* Facebook
* Strava
Radu Pârvu's Site
* Oracle
* Autonomous
* Unjustly Ignored
* 19c
* DOC: Oracle Database 19c
* 12c
* 11g
* SQL Developer
* Certification
* Metalink
* OCI
* Oracle Cloud Sign In
* Tech
* Database
* Apple
* Mac OS X
* Big Nerd Ranch
* Unix
* Linux
* OEL
* Solaris
* FreeBSD
* Unix Commands
* Scripts Repository
* Blog
Menu
Open a search box Close a search box
Search for: Search
* Scripts
* Photos Expand child menu
* Finland Summer 2020
* About Me Expand child menu
* My Public Appearances
* På svenska Expand child menu
* Lätta Bladet
* 8 SIDOR
* Rivstart A1+A2
* Svenska Akademiens ordlista
* În Română
* Oracle Expand child menu
* Autonomous
* Unjustly Ignored
* 19c Expand child menu
* DOC: Oracle Database 19c
* 12c
* 11g
* SQL Developer
* Certification
* Metalink
* OCI
* Oracle Cloud Sign In
* Tech Expand child menu
* Database
* Apple Expand child menu
* Mac OS X
* Big Nerd Ranch
* Unix Expand child menu
* Linux Expand child menu
* OEL
* Solaris
* FreeBSD
* Unix Commands
* Scripts Repository
* Blog
TUESDAY POST: DATABASE SCHEMAS COMPARE
on 15/03/202214/03/2022by rparvuLeave a comment
One of the questions that arise during the development process is if the
database schéma I work on is an unaltered image of production. How do I know
that another developer didn’t experiment with a new index or modified the
structure of some table? Writing scripts to compare my current database with the
‘source of truth’ is time consuming! Luckily, Oracle SQL Developer has just the
feature to help me!
This procedure can be used to compare database objects of two databases to
ensure they are aligned between different environments.
* Run Oracle SQL Developer
* Menu -> Tools -> Database Diff
* Specify source and destination database
* Specify the type of objects you wish to compare, e.g. indexes etc.
* Specify the schema you want to compare, object types ans you may choose if
you wish to compare all objects or just certain objects
* After clicking ‘Finish’, it may take a while according to the size of the
schema and the number of objects to be compared:
* The report will list all objects which are missing/differ between the
compared databases, DDL statements can be picked up in order to bring the
database schemas in sync
* Repeat the steps for all schemas you want to compare
SHARE THIS:
* Email
* Share
*
*
* Telegram
* WhatsApp
* More
*
* Print
*
*
* Share
*
*
* Save
*
*
*
LIKE THIS:
Like Loading...
About the author: rparvu
View all posts by rparvu
* Personal website
Posted in: db Oracle SQL Developer tech
POST NAVIGATION
Previous Entry: ExoticSilicon.com – Index for ‘A reckless guide to OpenBSD’
RELATED
Is Oracle Autonomous Database the answer to the many database security issues?
(I)25/05/2020In "Autonomous"
Manage Sessions in Oracle Database20/01/2022In "19c"
Oracle Autonomous Transaction Processing: Client Setup20/03/2019In "Autonomous"
LEAVE A REPLY CANCEL REPLY
You must be logged in to post a comment.
COMING EVENTS
No upcoming events
1640988000
0 days
0 hours0 minutes0 seconds
until
--
LATEST NEWS
* Tuesday Post: Database schemas compare 15/03/2022
* ExoticSilicon.com – Index for ‘A reckless guide to OpenBSD’ 14/02/2022
* Om Finland 23/01/2022
* Benefits of Black Cumin Seed (Nigella Sativa) for Weight Loss |
NutritionFacts.org 23/01/2022
* War in Ukraine: Marshall Mud i… on The Eclectic Light Company
* The Word of God Is Living and… on Looking to God
* After you clone your pluggable… on Learning is not a spectator sport
* Manifestări dedicate martirilo… on Daniel Vla - Ortodoxie, Țară, Românism
* Gyms on SuperB Fitness Workouts
RECENT COMMENTS
Is Oracle Autonomous… on Is Oracle Autonomous Database…
ARCHIVES
Archives Select Month March 2022 (1) February 2022 (1) January 2022 (16)
December 2021 (5) November 2021 (4) October 2021 (1) September 2021 (1)
August 2021 (2) July 2021 (2) January 2021 (1) December 2020 (1) October
2020 (1) May 2020 (2) April 2020 (1) February 2020 (1) January 2020 (1)
November 2019 (1) August 2019 (1) April 2019 (1) March 2019 (2) February
2019 (2) August 2017 (2) October 2016 (1) March 2016 (2)
TAGS
Featured (16) På svenska (2) În Română (4)
CATEGORIES
Categories Select Category Lifestyle (12) Nutrition (3) Running (10)
Scripts (2) tech (34) Apple (7) Mac OS X (5) db (26)
Oracle (25) 11g (1) 12c (2) 19c (3)
Autonomous (9) OCI (2) SQL Developer (6)
Undocumented (1) Unjustly Ignored (2) SPOUG (1)
Unix (4) FreeBSD (1) Linux (2) OEL (1)
Uncategorized (4) World (15)
* Share on Facebook
* Share on Twitter
* Save
* Share on LinkedIn
* Share via Email
* Share on Tumblr
* Share on Reddit
Go to the top
* Radu Pârvu's Blog
* Technology Articles
* About Me
* My Public Appearances
* Certifications and Endorsements
* Database Articles
* På svenska
* În Română
* Main Page
* Scripts Repository
* Unix Commands
META
* Register
* Log in
* Entries feed
* Comments feed
* WordPress.org
DO YOU HAVE A QUESTION?
Call Radu
* På svenska
* În Română
* Linkedin
* Twitter
* Instagram
* Facebook
* Strava
%d bloggers like this:
Send to Email Address Your Name Your Email Address Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.