Aurora 4x

Starfire => SA Installation => Topic started by: Tregonsee on November 22, 2008, 05:20:43 PM

Title: Combining Datatbases
Post by: Tregonsee 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.
Title: Re: Combining Datatbases
Post by: Erik L 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.
Title: Re: Combining Datatbases
Post by: Tregonsee 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