Supporting eSync between v8.5 sites with Ektron Windows Service version 8.6 or higher

  • Updated

If you install an Ektron 8.6+ site to a server that also has one or more Ektron 8.5 sites, the Ektron 8.6+ Windows Service (EWS) replaces the 8.5 version. This update obsoletes the dbSync.config  file, which was integral to eSync in version 8.5.

To manage settings you previously configured in  dbsync.config  file, run the following script:

 

IF(NOT EXISTS(SELECT NAME FROM SYS.OBJECTS WHERE (NAME='sync_settings') AND (type='u')))

begin

create table [dbo].[sync_settings]

(

profile_id bigint not null,

memory_data_cache_size int not null default (32768),

remote_sql_connection tinyint not null default(2),

application_tran_size bigint not null default (0),

script_encryption bit not null default (0),

collision_action bigint not null default(0),

backup_action tinyint not null default(0),

backup_device nvarchar(max) null,

log_retain_count int not null default(50),

CONSTRAINT [PK_sync_settings] PRIMARY KEY CLUSTERED (profile_id)

)

end

go

if(not(exists(select 1 from sync_settings where profile_id=0)))

begin

insert into sync_settings(profile_id)values(0)

end

go