Hi, I would like to mix 2 databases for personal use. It's Daily and French 2013.
I want a Daily as base (stats), with added teams and races from French (Continental and .2 races) and also free riders from there. So my question - How to do it correctly?
I know Excel Editor: teams, sponsors should be realtively easy, riders - hmm when I let every team members as it is, delete free riders and only pick missing teams and free riders from other database (with changed IDs) It should be fine, right?
About others I have no clue How to do with races, Its races and stages xml or some others too?
Missed something?
Well, it's not really easy. You'll have to copy all the extra stuff but always making sure that no IDs are repeated. Races and stages should be the easiest (just copy their lines in STA_race/STA_stage and change IDs if needed), while teams, sponsors and specially riders will need a bit more work. I don't think it'll be possible to add all free riders from one DB to another - you'd need to compare the FA list from both DBs to take only the "extra" riders, which I don't even think there's a way to be done. You'll also need to delete the double riders (f.e. if you copy the whole roster of a team, you'll need to search individually for them in Daily's DB to see who was already in the DB and then delete this one, otherwise you'll have a duplicate of the same rider).
lluuiiggii wrote:
Well, it's not really easy. You'll have to copy all the extra stuff but always making sure that no IDs are repeated. Races and stages should be the easiest (just copy their lines in STA_race/STA_stage and change IDs if needed), while teams, sponsors and specially riders will need a bit more work. I don't think it'll be possible to add all free riders from one DB to another - you'd need to compare the FA list from both DBs to take only the "extra" riders, which I don't even think there's a way to be done. You'll also need to delete the double riders (f.e. if you copy the whole roster of a team, you'll need to search individually for them in Daily's DB to see who was already in the DB and then delete this one, otherwise you'll have a duplicate of the same rider).
hmm, this will be tough, but without start, it all be just fantasy
maybe I'll just add a few teams with riders, It will be easier
