Toad World® Forums

using data modeler to store stored procedures?


#1

Let us say I have stored procedures that change regularly. I can keep a note of these and reverse engineer these into data model and save it with a new version at the end of the day.

the other approach is to not to save stored procedures at all in the data model.

which is good? any thoughts.


#2

Hi,

What database do you use? Oracle?

Thanks for the info.

Regards,

Vladka


#3

The database I use is SQL server 2008


#4

Hi,

Thanks.
Reading your question again and again we are finding out that we are not sure what you want to do. Sorry.

You change some procedures in your db and want to load them into your existing model. Right? Unfortunately, during RE it is not possible to select particular procedures, all will be loaded. However, then you can do model merge of the newly reversed model and the existing one. To do it at one jump, you can use the Model Update feature (Model menu). The procedures will be compared and TDM will show you those that are different. You can decide if you want to merge them or not.

Another scenario:

  1. Do RE of your model - select all objects you need except for procedures. The model (Model A) will not have any procedures.
  2. Do RE again - this time load only procedures. -> Model B will be created.
  3. When you need to add the procedures from Model B to Model A, feel free to do it. You can choose two methods:
  1. Click Model B (the model with procedures only).
  2. From Model B, open the Sync & Convert Wizard.
  3. Select Merge Models… Destination Model will be Model A.
  4. On page Select Items, right-click the Source model name and select Uncheck All Children.
  5. Right-click the Procedures item and select Check All Children. Click Next.
  6. On page Review, select the Merge to New Model checkbox. - Just for sure. A new Model C will be created and you can check out if it is what you want. (If you didn’t select the Merge to New Model checkbox, the Model A will be overwritten.)

Movie on model merge to better understand how to modify the items on page Select Items. PDF doc is also attached there:
http://modeling.inside.quest.com/entry.jspa?externalID=3028&categoryID=158

If I’ve misunderstood your question, please write me back. More details will be appreciated. Thanks.

Regards,

Vladka + TDM Team