Author Topic: DBMS Backups to File  (Read 4692 times)

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
DBMS Backups to File
« 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.


Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13387
  • Karma: +566/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: DBMS Backups to File
« Reply #1 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

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
Re: DBMS Backups to File
« Reply #2 on: November 01, 2015, 04:23:29 pm »
Thank you Geert for confirming.   That is what I would expect.  

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
Re: DBMS Backups to File
« Reply #3 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?

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8607
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: DBMS Backups to File
« Reply #4 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
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: DBMS Backups to File
« Reply #5 on: November 07, 2015, 02:51:11 am »
You can try to first clean the contents of t_secpolicies. This will disable security.

q.

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
Re: DBMS Backups to File
« Reply #6 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.