Author Topic: use DBMS with MS SQL to share project for my team (Read 6281 times)

kt1 · « **on:** September 25, 2006, 01:16:27 am »

Can you help me detail the way to use DBMS with MS SQL to share project for my team members ? How can I manage user ?

Thanks

Jan ´Bary´ Glas · « **Reply #1 on:** September 25, 2006, 01:28:17 am »

You may manage users in Corporate edition with enabled Security via Menu Project/Security. It is quite intuitive.
The other thing is db preparation, there is a lot of about it on EA User Group wiki http://wiki.eausergroup.org/index.php?title=How_do_I_setup_a_repository%3F.

HTH, Bary

kt1 · « **Reply #2 on:** September 25, 2006, 06:50:18 pm »

Hi,

Thanks for your responding. At now, I configured my system with MS SQL. It's OK. About manage user, can you tell me detail the way to execute? (How can I know who did? and when they did?)

Thanks

Dave_Bullet · « **Reply #3 on:** September 25, 2006, 08:39:20 pm »

As far as I know, there is no audit history maintained with user changes. 2 ways to do that are:
a) Enable version control (for that you will need a 3rd party SCC compliant version control tool)
b) Write your own triggers on EA base tables to insert changes into audit tables (that you create)

a) would be easiest to do. The version control tool will then be able to show you who checked in / out what packages, but to work out changes - you'd need to run a difference between them manually.

Cheers,
David.

kt1 · « **Reply #4 on:** September 26, 2006, 02:22:41 am »

Hi,

Thanks for your help. If I want to develop with my team members, I need use DBMS to share project and Version control to manage members ?

Can you give me other better solutions for my request?

Thanks

:o

Jan ´Bary´ Glas · « **Reply #5 on:** September 26, 2006, 02:25:42 am »

You will need the DB, but some (and sufficient for me) functions of member management is provided by EA. Search in Menu Project/Security

kt1 · « **Reply #6 on:** October 05, 2006, 03:15:04 am »

Hi,

With RDBMS, when I and my member modify same diagram, can it notify or resolve conflic between my product and product of my member? Can you give your ideas?

Thanks

StefanPears · « **Reply #7 on:** October 05, 2006, 06:08:55 am »

If you don't have a version control, you should check the "require user lock to edit" option in the security menu. Anyone must apply a lock to the element or package before he/she can edit. So you can avoid conflicts.
Stefan

kt1 · « **Reply #8 on:** October 05, 2006, 06:18:02 pm »

Hi,
Thanks for you anwser. Can you tell me detail about process of updating project with DBMS and "require user lock to edit"?

Thanks

StefanPears · « **Reply #9 on:** October 05, 2006, 11:00:55 pm »

select <help> <help contents>. Search for "user security". Read the Security Policy, Locking Model Elements, Enabling Security etc.
Btw.: As Jan mentioned before, everyone in your team must have the corporate edition (full version!) to use this feature.
Stefan

bioform · « **Reply #10 on:** October 30, 2006, 03:30:33 pm »

Actually there is maybe two brief paragraphs (less 150 words), the EA white paper on deployment is pretty good. But the wiki looks like it's dead...

Bruno.Cossi · « **Reply #11 on:** October 30, 2006, 04:47:04 pm »

Quote

Actually there is maybe two brief paragraphs (less 150 words), the EA white paper on deployment is pretty good. But the wiki looks like it's dead...

Hi,

the wiki is not dead, just a bit tired :-) It is a collaborative effort, anyone can edit and add more information - please feel free to add in your own findings.

Thanks,
Bruno

Sparx Systems Forum

News: