ThatJeffSmith

Tag: Compare

How to Compare PL/SQL and SQL in Oracle SQL Developer

This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny. Don’t be surprised they left extremely satisfied Then just yesterday, […]

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, […]

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 […]

SQL Developer Quick Tip – Pin Query Result Sets and Plans

It’s very rare that a query is developed in a single take. You start with a framework, and then trim down to the essential elements. Then you start working about sort orders, performance, and formatting. As you develop your SQL, you may want to keep several iterations of the data and their plans available. SQL […]

Toad Video: Compare & Sync Table Data Across Servers

Sit back and relax as I take you through one of my favorite Toad features: Data Compare. In less than five minutes see how to: Set your data comparison target and source Configure which columns to compare Use WHERE clause filters to limit data compared View the results Synchronize the data (optional)

INTRODUCING TOAD FOR SQL SERVER PT III

Up to this point, I have demonstrated my mastery of the Roman Numeral System, Toad’s IntelliSense and Group Execute technology, and Toad’s SQL Optimization technology. In this post I’ll finish the conversation with an overview of Toad’s Compare and Synch feature set. For your reading enjoyment and my time constraints and sanity, I will show […]