2022.2

however,thatthealternatevendordatabase(s)must already be installed and availableinordertoswap
tothem.
Thisisnotamigrationtool.Itisasimpleconnectiontool,thatenablesshiftingtoadifferentback-end
database.Anyexistingdatawillnotbetransferred/migratedbetweenthedatabases,andanyexisting
FileStoreswillbecleansedbytheClean-upServiceaftertheswap.
Whenshiftingtoadifferentback-enddatabase,thechangeswon'tbeapplieduntilPlanetPressCon-
nectisrestarted.IncludingtheConnectservices.Afullmachinerestartisrecommended,asthis
providesthecleanestrestartofalltheservices.
l
Basic Connection Settingsselections:
l
Database vendor:Selectthedatabasetypefromthedropdownlist.
Note: Movingfromonevendordatabasetoanotherwillresetallscreenselectionsto
defaults,regardlessofwhatmayhavebeenpreviouslyselected.
l
Database URL:Thisisaread-onlysummationofthecurrentdatabaseconnectionset-
tings.
Tip: IftheTest Connectionbuttonshowsthatthedatabasecannotbesuccessfully
connectedtousingtheselectedsettings,thenthecontentsofthisfieldcouldbeused
totrytoconnecttothedatabaseoutsideofPlanetPressConnect.Thisshouldhelpin
determiningandrefiningtheacceptableconnectionoptions.
l
Hostname:EntertheIPAddressoraliasoftheserverwheredatabaseresides.
l
Database Instance Name:EnteranexistingMicrosoftSQLServer'sinstancename.
ThisoptiononlyappliestoexistingMicrosoftSQLServerinstances,andnotforMariaDBor
MySQL.
l
Port:EnterPortnumber.Thedefaultsarethosewhichthevendorsusebydefault.
l
Schema:Theindividualdatabaseschema,withinthevendordatabase.
Note: Ifapreviouslynon-existentschemawerechosenhere,thenanewschemaof
thatnamewillbecreatedwithinthedatabasewhentheback-enddatabaseswapis
applied.Thetableswithinthatschema,though,willnotbecreateduntilConnectis
restarted.
l
Username:Enterthedatabaseloginusername.
Tip: Itisconsideredbestpracticeforthisusertohaverootprivileges.
Page 788