Pervasive DataExchange User's Guide 2.5 - Contents

Pervasive DataExchange 2.5 (code XUG, revision 1)   Sync manual in Pervasive Library

About This Manual

Who Should Read This Manual

Manual Organization

Pervasive DataExchange

Real-Time Backup Edition

Data Synchronization Edition

DataExchange Tools and Utilities

Supplemental Information

Conventions

Pervasive DataExchange

Introducing Pervasive DataExchange

Understanding Pervasive DataExchange and its Capabilities

DataExchange Overview

DataExchange Editions

Real-Time Backup Edition

Data Synchronization Edition

DataExchange Components

DataExchange Utilities

DataExchange Documentation

Pervasive DataExchange Basics

An Overview of DataExchange Basics

Starting and Stopping the Replication Engine

As a Service

As a Console Application

Starting and Stopping the DXAgent Service

As a Service

Logins and Permissions

ODBC Basic Concepts

Servers and Clients

Data Source Names

Pervasive.SQL Security

Deploying DEMODATA Under Pervasive.SQL Security

Real-Time Backup Edition

Real-Time Backup Deployment Models

A Look at Alternative Deployment Models for Real-Time Backup

Real-Time Backup Configurations

Two Machine Configuration

Many-to-One Configuration

Replication Deployment using DXDeploy

Replication Deployment using Designer

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

Sample Database Changes

Initiate Replication

Verify the Changes were Replicated

Many-to-One Deployment using DXDeploy

Disaster Recovery

Failover

No Data Recoverable

Data Recoverable But Not Current

Data Synchronization Edition

Data Synchronization Deployment Models

A Look at Deployment Models Available for Data Synchronization

Data Synchronization Deployment Methods

DataExchange Implementation Options

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

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 the Template Design

Copy First Site files to the Partner Site

Activate the First Site Template

Activate the Partner Site Template

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

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

Sample Database Changes

Initiate Replication

Verify the Changes were Replicated

Example Database Design for Data Synchronization

Understanding Database Design Considerations 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

A Reference for Using the DataExchange Utilities and Services

Utilities and Services Overview

Replication Stages and the Utilities Used

Accessing the Utilities

Replication Shortcuts

Command-line Utilities

dxcleanup

dxregevnt

dxact

dxdeact

dxdeploy

dxdynpath

dxsynctables

ffcopy

GUI-based Utilities

da

prd

pvreplcm

trwizard

Services

dxagent

replserv

Using the DataExchange Designer

A Tour of the DataExchange Designer Features and Functionality

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

A Tour of DataExchange Manager Utility

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 DataExchange Monitoring Tools

A Brief Look at the DataExchange Monitoring Tools

DataExchange Monitoring Tools Concepts

Initiate Replication

Site IP Address or Host Name Changes

Logging Options

DataExchange Monitoring Tools GUI Visual Reference

Main Window

Menu and Toolbar

Statistics and Log View

DataExchange Monitoring Tools Tasks

General Tasks

Replication Tasks

Administrative Tasks

Supplemental Information

Basic Troubleshooting

How to Identify and Solve Common Problems

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

PvReplCM Process

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

Pervasive DataExchange Data Types

Data Types

Notes on Data Types

DECIMAL

NUMERIC, BIGINT, UBIGINT and CURRENCY

CHAR

VARCHAR

IDENTITY

Reserved Table Names C

Pervasive DataExchange Reserved Words and Table Names

DataExchange Reserved Words

DataExchange System Table Names C

DataExchange (PDC) User Table Names C

Other Limitations C

Pervasive Software Resources and Contacts D

A Guide to Pervasive Customer Information Resources

Available Resources

Developer Center D

Pervasive.SQL Knowledge Base D

FTP Site D

Webinars D

Subscription Based E-mail Services D

DevTalk D

Newsgroup D

E-Mail Contacts D

Technical Support D

D

Advanced Topics

A Look at Advanced Topics for Pervasive DataExchange

Installing DataExchange as Part of Your Application E

How To Perform a Silent Install E

F Glossary F

Replication Terminology

Accelerated F

Activated Database F

Auto-subscription F

Base Table / Dependent Table F

Cascading Deletions F

Change Capture / Change Apply F

Control Table F

DataExchange Designer F

DataExchange Manager F

Design (Rules) F

DNA F

Encryption F

First Site F

Fragment F

Global Table F

Globally-Unique IDs F

Hub and Spoke F

Local Table F

N-Tiered F

Network F

ODBC F

Operations F

Partner Site F

Peer to Peer F

Permissions F

Project F

Refresh F

Release F

Replication F

Replication Engine F

Replication Network F

Replication Template F

Rights F

Rules (Design) F

Site F

Slice F

Subscription F

Template F

Transaction Group F

Transaction Set F

Work Set F