Toad World® Forums

Refactoring Utility Broken?

I have a fairly large database that I’m moving to a different server and need to refactor a lot of objects. When I choose “Tools --> Refactoring Utility” there are NO objects listed. It looks NOTHING like the the screen shots in the help utility.

Is this feature broken? How can I get it to work?

Regards,

Dan.

Hi,

when you change object name in your model, the item will apper in the Refactoring Utility. The Utility allows you to list objects with modified name and affected objects. E.g. change name of attribute in your entity. If the attribute is used in stored procedure, the refactoring utility will help you to automatically update the code of your stored procedure etc.

Regards,

Vaclav

Vaclav,

Thanks for the feedback. That wasn’t clear. I thought that it was a utility to globally change a large number of object names.

The source DB is an analytical DB with over 2,600 objects (tables, views, stored procedures) from multiple organizations and used some odd naming conventions. As part of moving about 500 of these objects to our new server, I’m cleaning up the naming. This will remove at least 10 characters from each object name making the far more readable. For example, from “tblrefOrgnameCustomer” to “tblCustomer”. So…

Is there a utility to globally rename object names?

Regards,

Dan

Would like some feedback on the follow up question.

Thanks,

Dan

Hi Dan,

I understand what you need. If you reverse engineered your database and did not chnage captions, you can take advantage of the Naming Conventions feature.

You can define new glossary and specify word replacement values, e.g.
tblrefOrgnameCustomer=tblCustomer
tblrefOrgnameOrder=tblOrder

There is a movie that shows how to define glossaries:

http://modeling.inside.quest.com/entry.jspa?externalID=3035&categoryID=158

And in the following movie you can see how to modify multiple items at once:

http://modeling.inside.quest.com/servlet/KbServlet/download/3033-102-6300/NC_Apply_Verify_ExistingModel.htm

Regards,

Vaclav

Thanks for the fast feedback. This looks like it should work.

Regards,

Dan.

Vaclav,

Hi. I tried the glossary, but that doesn’t do what I want to do. It looks like it only works with single characters and whole words.

For example, I have a table called “tblrefTableName”. I want to name it to “tblTableName”. I.e. I want to replace a string of characters that is NOT the whole table name.

How can I do that without specifying each table name in the glossary?

Thanks,

Dan.

Hi Dan,

I think if you wish to change part of names and apply specific rules, e.g. remove 3 chars starting at position 3 etc… then I recommend you to use custom script.

Short introduction:
http://blogs.inside.quest.com/modeling/2012/01/04/scripting-window-tdm/

Regards,

Vaclav