Book a Demo

Author Topic: EA repository backup  (Read 3735 times)

SwissSteve

  • EA User
  • **
  • Posts: 42
  • Karma: +0/-0
    • View Profile
EA repository backup
« on: November 04, 2008, 12:36:14 am »
Hi,

I was wondering what is the best approach to backing up a DB EA repository.

SwissSteve

  • EA User
  • **
  • Posts: 42
  • Karma: +0/-0
    • View Profile
Re: EA repository backup
« Reply #1 on: November 04, 2008, 01:43:26 am »
Found the batch XMI command and was wondering if it is possible to run this command outside of EA. then I could setup a script ot perform this export nightly, this would be probably better than doing a DB backup.

Any thoughts from the forum?

SwissSteve

  • EA User
  • **
  • Posts: 42
  • Karma: +0/-0
    • View Profile
Re: EA repository backup
« Reply #2 on: November 04, 2008, 07:30:32 am »
For anyone who is interested, I decided to use XMI to export my model
from a C# batch application that I use to publish the HTML version of the model + import into Confluence

For the record here is the line I added

    // Seems the method is touchly abot the format of the path c;/ etc will run but no output or warning

    Uri XMIFileName = new Uri(path.WebSite + "/XMLBackup/backup.xml");
  
    // The GUID is format {xxxxxxx-xxx-xxx-etc}

    string res = project.ExportPackageXMI(path.RootGUID, EA.EnumXMIType.xmiEADefault, 1, 3, 1, 1, XMIFileName.LocalPath);

I just gave the root GUID of the model as I wanted to export all packages from root.
    
« Last Edit: November 04, 2008, 07:31:10 am by SwissSteve »

Oliver F.

  • EA User
  • **
  • Posts: 573
  • Karma: +2/-1
  • Aren´t we all in the model business ?
    • View Profile
    • Karl Storz homepage
Re: EA repository backup
« Reply #3 on: November 04, 2008, 07:25:32 pm »
Quote
Found the batch XMI command and was wondering if it is possible to run this command outside of EA. then I could setup a script ot perform this export nightly, this would be probably better than doing a DB backup.

Any thoughts from the forum?

We use the baseline functionality run from an external daemon.
Each day a new baseline is created so we have the chance to see what has changed in a certain area and to restore it necessary.

HTH

Oliver

JPHespanha

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
  • et pluribus unum
    • View Profile
Re: EA repository backup
« Reply #4 on: November 05, 2008, 12:50:45 am »
You have presented interesting approaches to backup a DB repository.

I've just implemented a repository into PostgreSQL and also a version control supplied by Subversion (SVN). This gives me a sort of backup to the packages under version control, but is not the same as a DB Backup.

I am not a DBA, so I have simpler questions which you might answer:

If I use the backup facilities already existent in the database, should I consider:

1. Inclusion of Blob data;
2. Inclusion of OID's?

Apparently, and just checking the schema, none of the data types is being used by the EA repository, so I can disable their support in the backup. Is that so?
Joao Paulo Hespanha
OTB Research Institute
Technical University Delft