How transfer application users from PWD repository to new DB?

[Former Member]

Hallo!

I have got one problem. I want to do a new Repository of Sybase PowerDesigner with some changed parameters, but I want to have same application users in new database which I have got in the old one.

I have hurt about to transfer 3 tables.

One table have to be:

PMUSER

But do anyone done it before to give me any advice?

Thanks lot for any respond!

David

[former_member186838 · Accepted solution]

Hi,

don't think this is the supported way to "Copy" all your users from one repository to another.

Best way would be if you use LDAP server to manage this.

If you take a look in the Repository Metamodel.pdm (in the PowerDesignerxx\Example directory) under the User Management package you see the relationship between the 3 tables responsible for the Users (PMPERM, PMUSER, PMGUSR).

HTH

Stefan

[Former Member · Accepted solution]

Hi Stefan!

The LDAP connection is not setup yet.

I have got users saved in repository and when u say, that it isn't best way to copy data from these 3 tables, how u would do it without LDAP?

I think the data movement from tables will work, don't you?

Anyway, thanks a lot!

[former_member186838 · Accepted solution]

Hi,

as far as I can see from the Repository Metamodel.pdm only the 3 Tables are handle the user management. Move the data might be the quick way if you don't like to type in all users again via PD client. I'm not aware of a way using the PD Portal as well.

Guess the offical way is to move the complete repository using the steps in "Porting a Repository from one DBMS to another" of the PD documentation. Then you can delete the documents.