First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different [...]
Compare
Synching your Oracle SQL Developer Data Model with the Database
So you’ve been working on your data model, and you’re wondering how far ‘out of whack’ it is with the production or development database instance. Sometimes folks manage to compile changes into the database, bypassing your design process and rules. If you’re wondering how to compare 2 models instead of your model with the database, [...]
SQL Developer Database Diff – Compare Objects From Multiple Schemas
Ever wonder why Database Diff isn’t called Schema Diff? One reason is because SQL Developer actually allows you to select objects from more than one schema in the ‘Source’ connection for compares. Now, before you get around to testing this – as you should never believe what I say, trust but verify – two things [...]
Database Diff Enhancements in Oracle SQL Developer v3.2
In the current issue of Oracle Magazine, I have an article that discusses how to copy and compare Oracle objects using Oracle SQL Developer. ‘Make the Easy Move‘ was written using Oracle SQL Developer v3.1. As you know, version 3.2 was released several weeks ago, and one of the significant changes included was an update [...]
Quick Tip – Comparing Explain Plans with SQL Developer
SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you find yourself on that spectrum however, it’s pretty safe to assume that at some point you will look at an execution plan for insight [...]
1 2
Twitter
RSS
GooglePlus
Facebook