Go to DATABASE à COMPARE à SCHEMAS
Select the Source Schema
Add the Target Schema
Click Compare
Sync script will be generated.
Issue: (If Toad is not DBA Version)
By making a scheme level comparison between two schemes in toad. it
gives the difference with a Note, but unable to copy the same in the
notepad and execute it in the SQL PLUS.
The message is
"Script is view only because you do not have access to dba module functions
in Toad"
gives the difference with a Note, but unable to copy the same in the
notepad and execute it in the SQL PLUS.
The message is
"Script is view only because you do not have access to dba module functions
in Toad"
Solution :
Press
Ctrl + A ( Select All)
Ctrl + F ( Search )
Complete text will be copied to the test box on search dialog box.
Ctrl + C ( copy )
Ctrl + v ( paste ) in the editor.
In TOAD 12.1 it does not work like this anymore. However, it seems to work to use Windows API GetWindowText . This tool implements it for easy use:
ReplyDeletehttp://www.softwareok.de/?Download=GetWindowText