Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: ShadoCat
« on: November 14, 2009, 06:25:35 PM »

Thank you Stephen.

I'd deleted all my SA stuff.
Posted by: Shinanygnz
« 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
Posted by: ShadoCat
« 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?
Posted by: Shinanygnz
« 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