Book a Demo

Author Topic: How do I find out what server connection was used for a model?  (Read 2491 times)

mse

  • EA User
  • **
  • Posts: 308
  • Karma: +1/-0
    • View Profile
I'm trying to create another model with a connection to a server. I don't know how the original was created. I can open the .eap file in a text editor however and see some information. Is it possible to know how the connection was made based on this information so that I can added a new project to the same database? All I know is that my coworker mentioned it was a SQL database connection. Here is the string as shown in the .eap file. I replaced the project name with COMPANY_PROJECT.

EAConnectString:COMPANY_PROJECT--- DBType=1;Connect=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=COMPANY_PROJECT;Data Source=DATABASE4\EA_DMBS;LazyLoad=1;
« Last Edit: May 21, 2019, 10:06:36 pm by mse »

Mauricio Moya (Arquesoft)

  • EA User
  • **
  • Posts: 344
  • Karma: +8/-4
  • EA Consulting and development in Spanish
    • View Profile
    • Arquehub Azure Module
Re: How do I find out what server connection was used for a model?
« Reply #1 on: May 22, 2019, 12:13:33 am »
You have to create a different database to store a new model. Each "eap" file requires one independent database. So you can create a new database on the same server, then transfer a local EAP into you new database. You can find the script to create the tables structure in the Resources section of Sparx website