Author Topic: Combining Datatbases  (Read 501 times)

0 Members and 1 Guest are viewing this topic.

Offline Tregonsee

  • Sub-Lieutenant
  • ******
  • Posts: 104
    • View Profile
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 Luken

  • Administrator
  • Admiral of the Fleet
  • *****
  • Posts: 5005
  • Thanked: 78 times
    • View Profile
    • Arkayn Game Design
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

  • Sub-Lieutenant
  • ******
  • Posts: 104
    • View Profile
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
 

 

Sitemap 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51