How to have all changes in history by default

Toad for Oracle & DevOps Toolkit
1

Hello,

I am using Toad 9.5 with DBA module.

Is there a way(a setting, a module or a version change) to automatically log into the history all changes that I do manually like alter a table, split partition, etc ?

Thank you.

2

Some suggestions:

  1. Save all the changes you do as scripts that you rewrite and execute?

  2. There is this option in Toad (Database / Spool SQL) where all the generated
    sql statements are written to a file. Filter that one on DDL commands.

  3. Make an “image” (Database Definition File) of you current database layout (
    using Database / Compare) as a starting point and it is possible to compare a
    later situation with this starting point. That can give you differences and
    generate scripts too.

Groetjes,
Wim

On Thu, May 20, 2010 at 13:09, DC wrote:

Message from: D.C.

Hello,

I am using Toad 9.5 with DBA module.

Is there a way(a setting, a module or a version change) to automatically log
into the history all changes that I do manually like alter a table, split
partition, etc ?

Thank you.

Historical Messages

Author: DC
Date: Thu May 20 04:09:42 PDT 2010
Hello,

I am using Toad 9.5 with DBA module.

Is there a way(a setting, a module or a version change) to automatically log
into the history all changes that I do manually like alter a table, split
partition, etc ?

Thank you.

__
_______________________________________
3

Thanks for reply, I’ll look deeper into your recommendations.

(I have worked previously on MySQl with SqlYog as desktop admin tool.)

I just want to use Toad in a “visual” way to:

  • add tables
  • alter tables, partitions on tables, etc
  • modify stored procedures, etc

Then I just want to find all my changes in a “history”(for current session),
translated into nice sql, so that I can create patches, etc.

With SqlYog on Mysql this was available by default, so I was wondering if it is possible to do the same for Toad.