Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: bockfu on October 31, 2015, 04:04:43 am

Title: DBMS Backups to File
Post by: bockfu on October 31, 2015, 04:04:43 am

Can someone verify the Project/Project Transfer process does not impact the 'source'?  

Use Case: Save DBMS backup to EAP file
Goal: The model owner wants to save a snapshot of the project saved as DBMS on periodic bases to have a redundant backup.

I was just going to use the 'Transfer Type' of 'DBMS to File', but wanted to make sure this process will keep the DBMS as-is.

Title: Re: DBMS Backups to File
Post by: Geert Bellekens on October 31, 2015, 04:17:04 am

I can confirm that your source won't be changed in any way if you do a model transfer.

Geert

Title: Re: DBMS Backups to File
Post by: bockfu on November 01, 2015, 04:23:29 pm

Thank you Geert for confirming.   That is what I would expect.  

Title: Re: DBMS Backups to File
Post by: bockfu on November 06, 2015, 06:25:31 pm

So I successfully transfered DBMS to File.

When I open the file I am prompted for login/password which I wasn't expecting.

I have been unable to use my credentials to open the file.

Any pointers on this, for example, how to disable the security settings?

Title: Re: DBMS Backups to File
Post by: Paolo F Cantoni on November 06, 2015, 07:33:47 pm

Quote

So I successfully transfered DBMS to File.

When I open the file I am prompted for login/password which I wasn't expecting.

I have been unable to use my credentials to open the file.

Any pointers on this, for example, how to disable the security settings?

There's a known bug regarding the two types of password encryption.  
I posted it about a month or so ago.  You should be able to search for it in Bugs and Issues.  That may be what you are seeing.

HTH,
Paolo

Title: Re: DBMS Backups to File
Post by: qwerty on November 07, 2015, 02:51:11 am

You can try to first clean the contents of t_secpolicies. This will disable security.

q.

Title: Re: DBMS Backups to File
Post by: bockfu on November 12, 2015, 04:47:36 pm

root cause: the security used for the DB is applied to the saved file, but the authentication method is not functional once you access the file.

Fix (Workaround):  Create user manually with Admin permissions and manually set their password.   Transfer to File, open file, use user/password which was created manually.