2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPrintShop Mail Connect

351

352

353

354

355

356

357

358

359

360

Table Of Contents

NotethatthissettingonlyimpactshowdatesaredisplayedintheDataModel.Itdoesnotchangehow

datesarestoredintheConnectdatabase,norhowtheyaredisplayedinatemplate.

Database Connection preferences

DialogusedtochangethePrintShopMailConnectback-endDatabase.

Thisdialogsupportstheswappingoftheback-enddatabasebetweenvariousvendordatabases.Note,

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PrintShopMail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PrintShopMail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

Page 351