on 11-23-2015 4:22 PM
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
Hi Mike,
What DBMS are you using?
Thanks,
Adam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.