Book a Demo

Author Topic: Work Offline for a model using SQL server database in the backend  (Read 7329 times)

pH

  • EA User
  • **
  • Posts: 72
  • Karma: +0/-0
    • View Profile
Hi,
I have a model that is stored in backend SQL server. Currently no version control is being used. With this setup, does 'Work Offline' has any meaning? Will it help me to work offline without having connectivity to DB?

Thanks,
Praveen
<a href="http://webuml.org"><img src="http://webuml.org/images/webuml-badge.png" alt="Set UML Free!" style="border-width:0"></a>

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Work Offline for a model using SQL server database in the backend
« Reply #1 on: March 16, 2017, 07:34:56 pm »
No, work offline is only related to version control. Without a connection to  SQL server you don't have a model to work on.
If you need this type of thing then I would recommend to setup version control, and then checkout packages to a local .eap copy of the model.
In that case the version control system will make sure everything stays consistent (and you don't loose any work)

Geert

pH

  • EA User
  • **
  • Posts: 72
  • Karma: +0/-0
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #2 on: March 16, 2017, 07:45:33 pm »
Thanks.
It might be a good feature for EA to make local copy without having to connect to DB and then merge into DB later.

-pH
<a href="http://webuml.org"><img src="http://webuml.org/images/webuml-badge.png" alt="Set UML Free!" style="border-width:0"></a>

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Work Offline for a model using SQL server database in the backend
« Reply #3 on: March 16, 2017, 07:51:51 pm »
Thanks.
It might be a good feature for EA to make local copy without having to connect to DB and then merge into DB later.

-pH
That already exists and is called Version Control, everything else will be at least as complicated.

Geert

PeterHeintz

  • EA Practitioner
  • ***
  • Posts: 1001
  • Karma: +59/-18
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #4 on: March 16, 2017, 07:57:01 pm »
Feature to create a local copy is there. Project Transfer from SQL to *.eap.

However auto-merging would probably need human intelligence implemented in a machine.
With Version Control you avoid that (lock->change->commit).
Best regards,

Peter Heintz

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #5 on: March 16, 2017, 08:08:50 pm »
And don't start jiggling with Mickeysoft replicas. Only if you don't care about consistency of your models.

q.

pH

  • EA User
  • **
  • Posts: 72
  • Karma: +0/-0
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #6 on: March 17, 2017, 02:35:07 pm »
Thank you all.

@PeterHeintz ,
I did file transfer to *.eap file from the DBMS. When I try to open it, its asking for credentials. Its not taking the ones that I use to connect my model to EA. Which are credentials its expecting?
regards,
Praveen
<a href="http://webuml.org"><img src="http://webuml.org/images/webuml-badge.png" alt="Set UML Free!" style="border-width:0"></a>

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #7 on: March 17, 2017, 02:48:38 pm »
Sounds like security is enabled on that model (and accept windows authentication is also on). You'll need to explicitly set a password for your user in the model.

PeterHeintz

  • EA Practitioner
  • ***
  • Posts: 1001
  • Karma: +59/-18
    • View Profile
Re: Work Offline for a model using SQL server database in the backend
« Reply #8 on: March 17, 2017, 06:47:47 pm »
Or disable security in you local copy.
Best regards,

Peter Heintz