Author Topic: Combining Datatbases  (Read 4508 times)

0 Members and 1 Guest are viewing this topic.

Offline Tregonsee (OP)

  • Sub-Lieutenant
  • ******
  • Posts: 104
Combining Datatbases
« on: November 22, 2008, 05:20:43 PM »
Is it possible to combine SA databases?  I and a friend have been using SA in a Starfire campaign, and need to rsolve some battles.  I would think that the easiest way (if possible) is to either combine databases into the same instance of SA, or there may be a utility to upload fleets to a version of SA to run the battle simulator.
 

Offline Erik L

  • Administrator
  • Admiral of the Fleet
  • *****
  • Posts: 5670
  • Thanked: 390 times
  • Forum Admin
  • Discord Username: icehawke
Re: Combining Datatbases
« Reply #1 on: November 22, 2008, 07:56:54 PM »
Speaking from a purely database developer standpoint here...

The biggest issue I see would be conflicting primary ID's. Since database 1 contains a lot of info, and database 2 would contain a lot of data, most of which would not be the same, but the IDs would be, you'd get conflicting errors.

I'm not sure how SA would handle that, if it didn't crash outright. If you know anything about Access, you could go into the database and manually merge data, this would allow for unique IDs where needed, but would be a time consuming process.

Offline Tregonsee (OP)

  • Sub-Lieutenant
  • ******
  • Posts: 104
Re: Combining Datatbases
« Reply #2 on: November 22, 2008, 09:36:42 PM »
It is a shame there is not a utility that would allow you to load files like fleets easily and then add that new file to the other database