Author Topic: Combining Datatbases  (Read 3671 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: 5654
  • Thanked: 366 times
  • Forum Admin
  • Discord Username: icehawke
  • 2020 Supporter 2020 Supporter : Donate for 2020
    2022 Supporter 2022 Supporter : Donate for 2022
    Gold Supporter Gold Supporter : Support the forums with a Gold subscription
    2021 Supporter 2021 Supporter : Donate for 2021
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