Toad for Oracle - Community for development, administration, tuning, tips and tricks

Now you can use MyToad to execute scripts remotely.

In Toad for Oracle 11.6, use MyToad:

• Store script files with your Dropbox account
• View them via the Web
• Choose which ones to execute.

If you have multiple Toad installations, you can select the machine to execute the scripts.

This data is encrypted using 256-bit AES encryption.

Visit MyToad.ToadWorld.com

With MyToad...

• Each copy of Toad you have can be set up to use a single set of application data files.
• Backup - Dropbox provides a secure, online storage mechanism.
• Versioning - Dropbox automatically versions every file stored in it. You can roll back to an earlier version of a data file.

Learn more:

• Videos:
  • Remote Script Execution
  • User File Sync
• Blog
• Article

First-time use of MyToad

In Toad:

• Go to View| Toad Options | Online | MyToad Monitor.
• Check Enable MyToad and click OK.
  You will notice the Toad for Oracle MyToad Monitor icon displayed on your taskbar.
  
• Complete the Initial Setup dialog.
  Note: If you don't see the Initial Setup dialog, click the MyToad Monitor icon on your taskbar.
• Register with Dropbox or sign in if you have an account and click Allow to let Toad for Oracle connect with your Dropbox account.
• Go to mytoad.toadworld.com and sign in.
  • Once more, click Allow to let Toad for Oracle connect with your Dropbox account.
    On the Remote Script Execution page:
    • Enter database information or select it from the grid (not shown).
      
    • Select an uploaded script or enter an ad hoc query on the Query tab, such as:
      select * from all_users.
      
    • Click Execute.
      Optionally, you can enter an email address or mobile phone number to be notified of results.
    • Click Results. (The number of scripts executed will display next to Results when complete.)

Your client Toad does not have to be running to execute scripts remotely, but MyToadMonitor.exe does.

Enable user files syncing

In Toad:

Go to View | Toad Options | Online | Enable user files syncing

MyToad for mobile-device users

You can execute scripts using your mobile device.

• In Toad:
  • Select Enable MyToad in Options | Online as described above.
• On your mobile device:
  • Go to mytoad.toadworld.com.
  • Sign in or register for Dropbox.
  • Allow access to Toad for Oracle.