This blog will give you the necessary steps to migrate your MySQL BMF repository to another database of your choice. The following databases are supported by BMF: Oracle, SQL Server, MySQL and Sybase. We will be using the Data Migration Wizard that is provided to us by BMF.

The first step is to decide which database platform you would like to do the migration for. Once that is decided, we can begin.



Go...

An exhaustive look at Toad, that doesn’t take that long to read and see immediate improvement in your day-to-day use of the tool. If you are new to Toad, this will shorten the learning curve. If you have been using Toad for 10 years, this will ensure you are not overlooking features or workflows that have snuck in while you weren’t looking.

One of the most common TOAD questions or problem areas is with connecting to remote and/or local databases. The process and requirements are actually quite simple – yet this remains a high frequency question that seems to cause remarkable confusion. And not just for new Oracle or new TOAD users, as sometimes even old pros can forget and ask. They just often do a Homer Simpson “Doh”...

Sometimes you need to reference the value of an IN argument (an input, in Code Tester terminology) in your outcome. For example, under certain circumstances, the string returned by your function should be the same as the input value. Or perhaps the out value should be some part of the input value.

You could hard-code the same value you supplied in the Input Grid, but then if you change the input value, you have to...

For those of you who haven’t yet upgraded to Toad 10, or were perhaps waiting until the first minor release, here’s a quick synopsis of what really characterizes Toad 10.

 

Toad for Oracle v10 offers new features and many enhancements to existing features, all of it designed to augment your workflow and to enable you to get your job done more productively, more accurately and with better visibility of the environment...

Did you know that you can call Spotlight on DB2 LUW from Toad for DB2 LUW and vice versa? Well, ok maybe you did. If that’s the case, please move along, there’s nothing to see here. Still with me? Then read on!

Toad for DB2 LUW and Spotlight on DB2 LUW exist as separate executables on your workstation. You might now be thinking “no kidding, Ben.” That’s fine. After all, I have been called the Master of the Obvious. However,...

We all love TOAD – both the commercial and freeware versions. We love it because it’s simply the best Oracle productivity enhancing tool out there. A few weeks back, I mentioned the many other freeware offerings from Quest. So this week I thought I’d mention a few other freeware offerings that serve me nearly as much as TOAD – just in different functional areas. Here are my top five.

Step by step instructions for importing and exporting TOAD Report Manager reports (TRD -TOAD Report Definition format).

Toad for Oracle is a world-class enterprise query-develop-tune-administration tool for the Oracle database platform. This document attempts to differentiate Toad from the average Oracle IDE or query tool so that the reader can make an informed decision to invest in the Toad product family.

Following is a list of features and concepts that most commercial and even freeware offerings strive to deliver. Each feature will demonstrate clearly how Toad rises above the competition. If you can live with only the lowest-common-denominator features, then Toad may not be an easy sell. If, however, you need a tool to rescue from hairy situations, tune your systems, and automate those painful daily tasks, then Toad should be a clear winner.

...

Many TOAD users ask “How can I run my SQL script against a collection or even all my databases all at once (i.e. in a single step)?” The problem is they generally ask this question while in the Editor – which by definition works with but a single active database connection at a time. But if you simply save the editor contents to a SQL script file – you can then use the TOAD Script Manager to execute that script against any...