Posted by: ShadoCat
« on: November 14, 2009, 06:25:35 PM »Thank you Stephen.
I'd deleted all my SA stuff.
I'd deleted all my SA stuff.
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)
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