Author Topic: SA Upgrade script for v4.6  (Read 2277 times)

0 Members and 1 Guest are viewing this topic.

Offline Shinanygnz (OP)

  • Lieutenant
  • *******
  • S
  • Posts: 194
  • Thanked: 6 times
SA Upgrade script for v4.6
« on: November 07, 2009, 03:12:06 PM »
You can try this saupgrade script to go from v45 to v46.  It ran for me without any errors, so fingers crossed.  If you get any errors, post a reply and I'll tinker with it.  They're just likely to be a table copy order ones due to the inter-dependencies (e.g. can't create a record due to requirement for a record in another table)
Stephen

Code: [Select]
table 'Game' copy
table 'Race' copy
table 'App' copy
table 'WindowPosition' copy
table 'CommanderBonus' ignore
table 'CommanderNames' ignore
table 'ComponentType' ignore
table 'DamageTemplate' ignore
table 'EmpireTitles' ignore
table 'EventType' ignore
table 'ExtremePlanets' ignore
table 'InnerPlanets' ignore
table 'KnownSystems' ignore
table 'KnownSystemsUsed' copy
table 'Materials' ignore
table 'MiningNames' ignore
table 'Moons' ignore
table 'NameTheme' ignore
table 'NumOrder' ignore
table 'OuterPlanets' ignore
table 'PDModes' ignore
table 'PhoneticNames' ignore
table 'PlanetaryInstallation' ignore
table 'PlanetaryType' ignore
table 'PoliticalTreaty' ignore
table 'ProtoPlanets' ignore
table 'SetAtmosphere' ignore
table 'ShipNameType' ignore
table 'StellarType' ignore
table 'SystemAbundance' ignore
table 'SystemAge' ignore
table 'WealthUse' ignore
table 'Composition' ignore
table 'Gases' ignore
table 'GovType' ignore
table 'HullDescription' ignore
table 'PopulationDAC' ignore
table 'ResearchCategories' ignore
table 'ResearchField' ignore
table 'Scale005' ignore
table 'Scale01' ignore
table 'Scale03' ignore
table 'ShipNames' ignore
table 'SizeGasGiant' ignore
table 'SizeTerrestrial' ignore
table 'SpareNames' ignore
table 'SpareNamesBackup' ignore
table 'TechSystem' copy
table 'Tectonics' ignore
table 'DivisionType' ignore
table 'FGNicknames' ignore
table 'LineNames' ignore
table 'Ruin' ignore
table 'TaskType' ignore
table 'TeamType' ignore
table 'TechType' ignore
table 'Theme' ignore
table 'ThemeClass' ignore
table 'ThemeRank' ignore
table 'ThemeSystem' ignore
table 'TradeGoods' ignore
table 'TraitGroup' ignore
table 'TraitsList' ignore
table 'AssignmentTypeFilter' ignore
table 'CargoType' ignore
table 'Condition' ignore
table 'ConditionalOrders' ignore
table 'RandomNames' ignore
table 'SpecialOrders' ignore
table 'StaffRoles' ignore
table 'StartingTechGroups' ignore
table 'System' copy
table 'Star' copy
table 'SolSystemBodies' copy
table 'WarpPoint' copy
table 'SurveyLocation' copy
table 'RaceSysMapDisplay' copy
       add 'HideCMC' 0
table 'SystemBody' copy
table 'RaceMapDisplay' copy
table 'SystemBodyName' copy
table 'MineralDeposit' copy
table 'SystemBodySurveys' copy
table 'RaceSurveyLocation' copy
table 'RaceSysSurvey' copy
table 'RaceSystemName' copy
table 'RaceWPSurvey' copy
table 'Waypoint' copy
table 'WealthData' copy
table 'RaceTech' copy
table 'RaceDesignTech' copy
table 'MissileSeries' copy
table 'Missiles' copy
table 'Population' copy
table 'Shipyard' copy
table 'ShipyardNames' copy
table 'ShipyardTask' copy
table 'Fleet' copy
table 'Ranks' copy
table 'Commander' copy
table 'CmdrTraits' copy
table 'ShipClass' copy
table 'ShipDesignComponents' copy
table 'Ship' copy
table 'ShipHistory' copy
table 'ShipNamesUsed' copy
table 'ShipCargo' copy
table 'AlienRace' copy
table 'AlienClass' copy
table 'AlienClassSensor' copy
table 'AlienClassSummary' copy
table 'AlienClassWeapon' copy
table 'AlienShip' copy
table 'Wrecks' copy
table 'WreckComponents' copy
table 'WreckTech' copy
table 'NPRClasses' copy
table 'NPRClassComponent' copy
table 'NPRClassMaterials' copy
table 'NPRClassOrdnance' copy
table 'AlienScan' copy
table 'AlienSystem' copy
table 'ArmourDamage' copy
table 'BannedBodies' copy
table 'BannedSystems' copy
table 'CIWSFired' copy
table 'ClassComponent' copy
table 'ClassMaterials' copy
table 'ClassOrdnance' copy
table 'ClassSC' copy
table 'CombatText' copy
table 'Contacts' copy
table 'CurrentDesigns' copy
table 'DamagedComponent' copy
table 'DCQueue' copy
table 'DefaultEventColour' copy
table 'DesignPhilosophy' copy
table 'Division' copy
table 'ECCMAssignment' copy
table 'EventColour' copy
table 'FireControlAssignment' copy
table 'FireControlPDMode' copy
table 'FireResult' copy
table 'Fires' copy
table 'FleetHistory' copy
table 'FleetMove' copy
table 'ForeignAid' copy
table 'Formation' copy
table 'GameLog' copy
table 'GUTraining' copy
table 'HideEvents' copy
table 'IndustrialProjects' copy
table 'IndustryStatus' copy
table 'KnownRuinRace' copy
table 'LGPoint' copy
table 'Lifepods' copy
table 'MapLabel' copy
table 'MDPackets' copy
table 'MedalsAwarded' copy
table 'Messages' copy
table 'MissileAssignment' copy
table 'MissileGeoSurvey' copy
table 'MissileSalvo' copy
table 'MoveAction' copy
table 'NPRClassType' copy
table 'NPRFleetOrders' copy
table 'NPRFleetType' copy
table 'NPRRaceType' copy
table 'Paste Errors' ignore
table 'PausedResearch' copy
table 'PopBombardRating' copy
table 'PopComponent' copy
table 'PopMDChanges' copy
table 'PopMDChangesTemp' copy
table 'PopPoliticalStatus' copy
table 'PopTradeBalance' copy
table 'PopulationWeapon' copy
table 'PrefabPDCs' copy
table 'ProductionQueue' copy
table 'RaceClassName' copy
table 'RaceMedals' copy
table 'RaceModifiers' copy
table 'RacialRelations' copy
table 'ResearchQueue' copy
table 'RuinRace' copy
table 'SBGas' copy
table 'SecondaryCmdrTheme' copy
table 'SectorCommand' copy
table 'SensorChecks' copy
table 'ShippingLines' copy
table 'ShippingWealthData' copy
table 'ShipTechData' copy
table 'ShipWeapon' copy
table 'Species' copy
table 'SpyPoints' copy
table 'Squadrons' copy
table 'StoredSBGas' copy
table 'StoredStars' copy
table 'StoredSystemBodies' copy
table 'StoredSystems' copy
table 'SystemDisplay' copy
table 'SystemNotes' copy
table 'TaskForce' copy
table 'Teams' copy
table 'TempAssignment' copy
table 'TradeOffer' copy
table 'WeaponAssignment' copy
table 'WeaponRecharge' copy
 

Offline ShadoCat

  • Commander
  • *********
  • Posts: 327
  • Thanked: 1 times
    • http://www.assistsolar.com
Re: Patch for v4.6
« Reply #1 on: November 14, 2009, 01:06:53 AM »
Quote from: "Shinanygnz"
You can try this saupgrade script to go from v45 to v46.  It ran for me without any errors, so fingers crossed.  If you get any errors, post a reply and I'll tinker with it.  They're just likely to be a table copy order ones due to the inter-dependencies (e.g. can't create a record due to requirement for a record in another table)

Can  you post a link for saupgrade and maybe a quick how to?

Offline Shinanygnz (OP)

  • Lieutenant
  • *******
  • S
  • Posts: 194
  • Thanked: 6 times
Re: Patch for v4.6
« Reply #2 on: November 14, 2009, 10:22:21 AM »
You can get the saupgrade executable from here, http://www.dreadfest.com/satools/saupgrade.html
I used to host a copy, but my old ISP finally killed my site (about 3 years after I left them), and I have never bothered creating a site with my current ISP.

It's pretty simple to run the script.  Here are some instructions:
1. Create a folder and copy saupgrade.exe, the new database and your old database to it.
2. Rename these old and new databases to something easy.  I usually call rename them after the version they are, e.g. v45.mdb and v46.mdb
3. Create a blank text file and copy the stuff I posted to it.  Call the file something simple too.  I usually call it v<old>to<new>, so to continue the example, v45to46 (no need for a file extension, but you can if you want)
4. Open a command prompt and cd to the folder where all these files are
5. Run this: saupgrade <old db> <new db> <scriptfile>
Note that you do need the full file name including the extension.  The example continues, saupgrade v45.mdb v46.mdb v45to46

Stephen
 

Offline ShadoCat

  • Commander
  • *********
  • Posts: 327
  • Thanked: 1 times
    • http://www.assistsolar.com
Re: Patch for v4.6
« Reply #3 on: November 14, 2009, 06:25:35 PM »
Thank you Stephen.

I'd deleted all my SA stuff.