What is Oracle SQL Developer? Well, according to this document on OTN… What is SQL Developer? Date: May 2014 Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer’s main objective is to help …
Connecting to Access, DB2, MySQL, SQL Server, Sybase, & Teradata with SQL Developer
SQL Developer is built by Oracle, for Oracle. It’s the database IDE. That’s my current elevator pitch, at least. But, SQL Developer is also a fully featured data modeling solution (have you been enjoying my data modeling posts?) AND a 3rd party database migration platform. The migration piece is the Migration Workbench. Since we support migrations from these other database …
Hint Abuse: SQL Server vs Oracle
I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster. This probably causes more problems than it solves, and rather trying to rehash what I’ve heard second hand, I suggest you go listen to a MSFT MCM talk about …
Moving Data to Oracle with Migration Workbench
I’ve been referring customers to SQL Developer’s Migration Workbench for a few months now. I thought it might be a good idea to give it a try myself before I send any more children out to play with the wolves. This is NOT a formalized review. This is a quick glance at a cool tool from a cool vendor. I …
SQL Server VS Oracle: Index Monitoring
Jealousy is not an emotion I generally feel for the SQL Server technology stack. I covet their Twitter camaraderie, but I ‘know’ that Oracle can counter just about anything thrown at it. People that Helped Me with this Post I was reminded that even old dogs can be taught new tricks while monitoring the #SQLSaturday conversation going on in Chicago …
Oracle vs SQL Server, Take II
Missed PT I?: Read Part I my favorite aspects of each RDBMS platform Update: Read PT III where I talk about monitoring indexes I had the pleasure of hanging out with @oraclenerd and @SQLChicken earlier this year in Tampa, FL. It was remarkable for a couple of reasons, but what I remember most is playing translator. When @SQLChicken would rave …
SQL Server vs Oracle Via Toad
This is not a volley in the RDMBS wars. This is a quick cheat sheet for getting started using Toad for SQL Server if you are already used to using Toad for Oracle. Pages not Windows Toad for Oracle is a classic Windows application that utilizes a classic MDI presentation. Toad for SQL Server uses ‘Document Tabs’ for each ‘Window’ …