DataExchange User's Guide - Table of Contents

Pervasive DataExchange v2.8 (code XUG_280, revision )  Sync manual in Pervasive Library

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Pervasive DataExchange

Introducing Pervasive DataExchange

DataExchange Overview

DataExchange Editions

Real-Time Backup Edition

Data Synchronization Edition

DataExchange Components

DataExchange Utilities

DataExchange Documentation

Pervasive DataExchange Basics

Starting and Stopping Replication

As a Service

As a Console Application

From Pervasive Control Center

Starting and Stopping the DXAgent Service

As a Service

From Pervasive Control Center

ODBC Basic Concepts

Servers and Clients

Data Source Names

Pervasive.SQL Security

Deploying Demodata Under Pervasive.SQL Security

Using Pervasive DataExchange

Activation

Activation and Data Source Names

Activating First and Partner Sites

Deactivation

Reactivation

Adding Tables to an Activated Database

Before you Begin

Determine Event Handler DLL Usage

Verify the Table Exists in the Pervasive Database

Deactivate all Sites

Add the New Table to the Replication Template

Identify Data (DDFs, D- and PDC Tables)

Activate Sites and Synchronize

Verify the Replication Session

Removing Tables From an Activated Database

Before you Begin

Deactivate all Sites

Remove Table From the Replication Template

Identify Data (DDFs, D- and PDC Tables)

Activate all Sites

Verify the Replication Session

Adding Dynamic Tables to an Activated Database

Before you Begin

Include File Patterns

Exclude File Patterns

Setting up Nondatabase File Replication

Before You Begin

Set Log On Properties

Create New Flat File Database

Execute the SQL Queries

Create the Design Template

Copy Files

Activate all Sites

Restart DX Services

Redesign Dxevent Table

Create Site Shares

Configure Flat File Replication

Changing a Table Structure in an Activated Database

Before you Begin

Clone PDC Table(s)

Copy Files

Verify the Replication Session

Real-Time Backup Edition

Real-Time Backup Deployment Models

Real-Time Backup Configurations

Two-Machine Configuration

Many-to-One Configuration

Replication Deployment using the Deployment Tool

Replication Deployment using DXDeploy

Replication Deployment Using Designer

Before You Get Started

Create a Template on the First Site Using Designer

Copy the Template Files to the Partner Site

Activate the Template on the First Site

Activate the Template on the Partner Site

Make Sample Database Changes

Initiate Replication

Verify the Changes Were Replicated

Many-to-One Deployment using DXDeploy

Before You Get Started

Deploying Using DXDeploy

Disaster Recovery

Failover

No Data Recoverable

Data Recoverable But Not Current

Data Synchronization Edition

Data Synchronization Deployment Models

Data Synchronization Deployment Methods

DataExchange Implementation Options

DataExchange Deployment Tool

DataExchange DXDeploy Utility

DataExchange Designer and Utilities

Where To Go From Here

Working with the Examples

Removing Databases Deployed with DXDeploy

Removing Databases Deployed with Designer

Replication Deployment Using the Deployment Tool

1-Way Deployment Using DXDeploy

Before You Get Started

Create the XML Descriptor File

Run DXDeploy on the First Site

Copy the Template to the Partner Site

Run DXDeploy on the Partner Site

1-Way Deployment Using Designer

Before You Get Started

Create a Template on the First Site Using Designer

Copy First Site Files to the Partner Site

Activate the First Site Template

Activate the Partner Site Template

Make Sample Database Changes

Initiate Replication

Verify the Changes Were Replicated

2-Way Simple Deployment Using DXDeploy

Before You Get Started

Create the XML Descriptor File

Run DXDeploy on the First Site

Copy the Template to the Partner Site

Run DXDeploy on the Partner Site

2-Way Simple Deployment Using Designer

Before You Get Started

Create the Template Design

Copy First Site files to the Partner Site

Activate the First Site Template

Activate the Partner Site Template

Make Sample Database Changes

Initiate Replication

Verify the Changes Were Replicated

2-Way Advanced Deployment Using Designer

Before You Get Started

Create the Template Design

Copy First Site Files to the Partner Site

Activate the First Site Template

Activate the Partner Site Template

Make Sample Database Changes

Initiate Replication

Verify the Changes Were Replicated

Example Database Design for Data Synchronization

Data Synchronization Design Considerations

Application Overview

Basic Data Synchronization Design

Database Selection

Database Identification

Replicated Tables

Advanced Data Synchronization Design

Fragments

Work Sets and Base Tables

Transaction Sets

Security

Sample Tracker Database

DataExchange Tools and Utilities

Using the DataExchange Utilities and Services

Utilities and Services Overview

Replication Stages and the Utilities Used

Accessing the Utilities

Command-line Utilities

dxact

dxcleanup

dxdeact

dxdeploy

dxdynpath

Types of Expressions

dxregevnt

dxrepl

dxsynctables

ffcopy

GUI-based Utilities

da

prd

replmonitor

dpwizard

trwizard

Services

dxagent

replserv

Using the DataExchange Designer

DataExchange Designer Concepts

Overview

1-Way / 2-Way Simple Methods

2-Way Advanced Method

Design Completion

Administration

DataExchange Designer GUI Visual Reference

Main Window

Designer Menu and Toolbar

Database Design pane

Table Design pane

DataExchange Designer Tasks

General Tasks

Basic Design Tasks

Advanced Design Tasks

Design Completion Tasks

Administrative Tasks

Using DataExchange Manager

DataExchange Manager Concepts

Managing Replication Schedules

Managing Site Information

Managing Users

Managing Permissions

Managing Data Subscriptions

DataExchange Manager GUI Visual Reference

Main Window

DataExchange Manager Tasks

General Tasks

Schedule Tasks

Site Information Tasks

User Tasks

Data Subscription Tasks

Using the Replication Progress and Log Viewers

Checking the Replication Engine and Service

Initiating Replication from the Progress and Log Viewers

Initiating a Replication Session

Reading the Initiate Replication Dialog Box

Recording and Monitoring Replication Activity

Setting Log Options

DRE Log File

Supplemental Information

Basic Troubleshooting

Troubleshooting Resources

Troubleshooting Strategies

Installation

Multiple DataExchange Designers

Terminal Services

Uninstalling

Network Communications

How to Start PSA

Documentation for PSA

Database Engine

Replication Engine

Log Files

Log File Size

Log File Descriptions

Data Replication

List of Sites to Replicate With Seems Inconsistent

Replication Fails for a Deactivated Site

False Alert Because of Schedule Manipulation

Correct Alarms but Replication on Wrong Schedule

Dynamically Created Tables Not Being Replicated

SQL Triggers and Replication

Data Conflicts (2-Way Advanced Only)

Conflict Types

Resolving Primary Key Conflicts

Data Conflicts When Activating Partner Sites

Index Segments

Notification Agent

Testing the Mail Server

How to Get Additional Help

Thirty-Day Free Technical Support

Supported Data Types

Data Types

Notes on Data Types

DECIMAL

NUMERIC, BIGINT, UBIGINT and CURRENCY

CHAR

VARCHAR

IDENTITY

Reserved Table Names

Other Limitations

Advanced Topics

Installing DataExchange as Part of Your Application

How To Perform a Silent Install

Pervasive Software Resources and Contacts

Available Resources

Developer Center

Pervasive.SQL Knowledge Base

FTP Site

Webinars

Subscription Based E-mail Services

DevTalk

Newsgroup

E-Mail Contacts

Technical Support

Glossary

Accelerated

Activated Database

Activation

Autosubscription

Base Table / Dependent Table

Cascading Deletions

Change Capture / Change Apply

Control Table

DataExchange Designer

DataExchange Manager

Design (Rules)

DNA

Encryption

First Site

Fragments (2-way advanced)

Global Table

Globally-Unique IDs

Hub and Spoke

In Place Activation

Local Table

N-Tiered

Network

ODBC

Operations

Partner Site

Peer-to-Peer

Permissions

Project

Refresh

Release

Replication

Replication Engine

Replication Network

Replication Template

Rights

Rules (Design)

Site

Slice

Subscription

Template

Transaction Group (2-way advanced)

Transaction Set (2-way advanced)

Work Sets (2-way advanced)