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)