Restaurar base de produção em DEV - gfrancischini/hbp_guide GitHub Wiki

Restaurar a base de produção utilizando o Bender.

Após conclusão verificar se os seguintes parametros estão com os apontaamentos corretos (servidor de dev)

cdProdcut	cdModule	cdParameter
Common	FileImport	OutputFolder
Common	FileImport	RootFolder
Common	FileSync	IntegrationServerPath
Common	FileSync	ReceivedServerPath
Common	Integration	FileIntegrationRootFolder
Common	FileSync	DiagnosticServerPath
Biz	PhantomInventoryTranslator	PhantomInventoryRootFolder
Common	MediaImport	RootFolder
Custom	HTMLBuilder	CachePath
Custom	Mailer	CachePath

Apagar arquivos pois eles não existem fisicamente e causam problemas de sync

update cmFile
set idStatus = 'REM',
flServerDeleted = 1,
dtLastModified = GETDATE()

update bzMedia
set flRemoteDelete = 1,
flServerDeleted = 1,
dtLastModified = GETDATE()

Apagar logs

truncate table cmException

Quick Fix

begin transaction

update v_cmconfigurationparameter
set vlConfigurationParameter = REPLACE ( vlConfigurationParameter , '\\SHR-RPFIT02\INTEGRATIONFILES\MASSCASH' , '\\BR-SRVVMDB-01\SpringWireless\Project\Shared\MASSCASH3\SB' ) 
,dtLastModified = GETDATE()
where vlConfigurationParameter  like '%\\SHR-RPFIT02\INTEGRATIONFILES\MASSCASH%'

--commit transaction