cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Databases in a single model

Former Member
0 Kudos

We have a single model spread over multiple databases, mainly for physical reasons.

I've set the

          EnableManyDatabases

in the DBMS properties of the database.

The database name disappeared from the model properties as it said in the help.

     If your DBMS supports multiple databases in a single model (enabled by the EnableManyDatabases entry in the Database category of the DBMS),      this field is not present, and is replaced by a list of databases in the Model menu. A Database category is also displayed in the physical options of your      database objects.

and I have a list of databases from the Model menu.

However, I don't have a "Database category" displayed in the physical options of the database objects.

Can anyone tell me how to specify which objects is in which db ?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182952
Active Participant
0 Kudos

Hi Mike,

What DBMS are you using?

Thanks,

Adam

Former Member
0 Kudos

Sorry for late reply been busy for a while.

We're using Sybase ASE 15.7 (SP132)

GeorgeMcGeachie
Active Contributor
0 Kudos

I've just created a new PDM using the ASE 15.7 definition, and the database definition file doesn't include an option 'EnableManyDatabases'. I'm only allowed to create a single database.

From a search of the xdb files in C:\Program Files\SAP\PowerDesigner 16\Resource Files\DBMS I can see that a few database definitions include this option, but ASE isn't one of them.

Former Member
0 Kudos

Sorry - just got back to looking at this.

By adding

          EnableManyDatabases

in the DBMS properties of the database.

The resource file for Sybase 15.7 has entries which (as much as I can tell) are the same as for

<o:BooleanTargetItem Id="o212">

<a:ObjectID>CDD9F3FF-1AE1-4DE4-85A2-CB7B25F33B38</a:ObjectID>

<a:Name>EnableManyDatabases</a:Name>

<a:CreationDate>1448293008</a:CreationDate>

<a:Creator>me</a:Creator>

<a:ModificationDate>1448293072</a:ModificationDate>

<a:Modifier>me</a:Modifier>

<a:Comment>Many databases allowed</a:Comment>

<a:Value>1</a:Value>

</o:BooleanTargetItem>

Maybe I'm reading too much into the page

Database Category (DBMS) - Customizing and Extending PowerDesigner - SAP Library

former_member192453
Active Participant
0 Kudos

You must modify the ::Script\Objects\Database\Options in your ASE XDB file. The existing template will not list the 'databases'.

I copied some code from the DB2 DBMS and it seems to answer your question.

The screen shot highlights the change I mad and the results.

Anthony