Ektron CMS400.Net Reference

>>Synchronizing Servers Using eSync > Using eSync > Synching Custom Database Tables

Synching Custom Database Tables

You can use eSync to synchronize a custom SQL database table. To do so, follow these steps.

1. Add a new, empty table to the target SQL database.

The table must have a primary key and cannot use identity columns. Here is an example of a valid table.

Create table foo3(Id int not null primary key clustered, Id2 int not null, company nvarchar(50) null)

Here are two examples of invalid tables. The identity columns are highlighted in red.

create table foo1(Id int not null identity(1,1) primary key clustered,company nvarchar(50) null)
create table foo2(Id int not null primary key clustered,Id2 bigint not null identity(1,1) ,comapny nvarchar(50) null

2. On the server that hosts the source database, navigate to C:\Program Files\Ektron\EktronWindowsService30.

3. Open the DbSync.config file.

4. Find the section that begins <Release version="8.0.2.

5. Within the 8.0.2 <Groups> tag, you see these names:

<add name="default" scope="ektron"

<add name="folder" scope="ektron"

<add name="content" scope="ektron"

<add name="folderrecursive" scope="ektron"

<add name="workflow" scope="workflow"

<add name="custom" scope="custom" schema=""/>

6. Enter your custom table schema within the last line’s schema="" tag.

Note: Follow the pattern of the existing schemata when adding yours.

7. Save DbSync.config.

8. Sign on the source server.

9. Follow steps 1 through 7 on that server.

10. Restart the Ektron Windows Service on both servers.

11. Run a DB sync from local to remote (local win).

(continued in Content and Folder Sync Options)


Visit the Ektron Dev Center at http://dev.ektron.com 1-866 - 4 - EKTRON

Ektron CMS400.NET Reference Version 8.02 SP1 Rev 1

Ektron Documentation,© 2011 Ektron, Inc.