StarQuest Data Replicator Technical Documents
- SQDR FAQ
- Article # SQV00DR006
This article answers frequently asked questions (FAQs) about the StarQuest Data Replicator (SQDR).
- SQDR Quick Start Guide
- Article # SQV00DR001
This document is a guide for installing and configuring the StarQuest Data Replicator. - Installing SQL Server for a Control Database
- Article # SQV00DR002
This document describes how to obtain and install the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and the SQL Server 2005 Express Edition to use as a control database for the StarQuest Data Replicator. - How to Install and Configure SQDR in a Windows Cluster Environment
- Article # SQV00DR019
The StarQuest Data Replicator (SQDR) can be managed as a Windows cluster resource and can provide high availablity during a failover scenario. - Creating a Secure, 2-Tier SQDR Environment
- Article # SQV00DR020
In certain environments, it may be necessary to secure SQDR and its dependent resources to prevent unauthorized use. This document describes how to set up a secure SQDR environment using methods that take advantage of Windows and SQL Server security. - How to Avoid a Baseline Replication after Source Table Schema Change
- Article # SQV00DR023
The document provides a method for avoiding downtime due to an altered source table schema. Specifically, it illustrates how to minimize the time needed to re-subscribe to the new version of the table, while exploiting the existing destination table and data. - Using Truncate to Minimize Logging Activity for DB2 Targets
- Article # SQV00DR024
This technical document describes techniques to minimize logging activity in certain situations when the destination system is running DB2. - Using SQDR Key Logging Data
- Article # SQV00DR021
SQDR provides a key logging feature that captures the incremental primary key data replicated to the destination database. This data may be helpful to dictate work flow operations. This document describes how to use SQDR to replicate the newly added records in the key logging table to another SQL Server database and present the data in a user-friendly format. - SQL Server Authentication Considerations
- Article # SQV00DR022
This document outlines the SQDR configuration and usage considerations when using a particular SQL Server authentication mode. - Cloning SQDR Subscriptions
- Article # SQV00DR011
This document provides instructions for cloning subscriptions from one SQDR 3.x system to an SQDR 3.x installation on a different computer. - Upgrading from a Prior Release of SQDR
- Article # SQV00DR005
This technical document provides instructions for upgrading the StarQuest Data Replicator (SQDR) for Windows software and discusses considerations related to the new features and functionality of the software. - Using SQDR for Limited Incremental Replication from SQL Server
- Article # SQV00DR017
This document describes a method for using StarQuest Data Replicator (SQDR) to simulate real-time replication from SQL Server to any database management system that SQDR supports (DB2, Oracle, or SQL Server). This is particularly useful for organizations that use SQL Server editions which do not include the Replication feature, such as the Standard and Workgroup editions. - Using SQDR for Limited Incremental Replication from SQL Server—Advanced
- Article # SQV00DR018
This document describes a method for using StarQuest Data Replicator (SQDR) to simulate real-time replication from SQL Server to any database management system that SQDR supports (DB2, Oracle, or SQL Server). This Advanced version of the procedures describes how to create the tracking table on the remote database instead of on the SQL Server computer to ensure that the entire operation succeeds or fails. - How to Replicate DB2 DATE and TIME Fields
- Article # SQV00DR004
This document explains how to replicate from DB2 Date and Time data types to the SQL Server Datetime or Smalldatetime data types. - Improving SQDR Performance
- Article # SQV00DR010
Use this document to help tune SQDR and the system environment to maximize performance. - Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
- Article # SQV00DR007
If the password for the SQL Server Administrator (sa) login changes, you may receive the following error message when launching the Data Replicator Manager: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. - Error Replicating Text or Image Data to SQL Server
- Article # SQV00DR013
This technical document describes a possible problem you may experience when replicating text or image columns containing null or zero-length data to SQL Server destination tables using the Replication Option native-loader function. - How to Replicate Oracle DATE Data Types to DB2 DATE Data Types
- Article # SQV00DR014
This document explains how to define an SQDR subscription that properly replicates Oracle Date data types to the DB2 Date data types. - How to Automatically Pause and Resume an SQDR Incremental Replication Group
- Article # SQV00DR015
This document explains how to schedule the execution of this script using the Windows Scheduled Tasks facility. - Automating SQDR tasks using COM (VBScript, Visual Basic or C#) and SQL Server Stored Procedures
- Article # SQV00DR025
This document explains how to control SQDR tasks programmatically, using SQL Server Stored Procedures or using COM with VBScript, Visual Basic or C#.
- How to Configure a Notification Alert for an SQDR Replication Event
- Article # SQV00DR008
This document explains how to configure job notifications, such as to notify an operator via email, pager email, or net send alerts when an SQDR replication fails, succeeds, or completes.
- How to Enable SQDR Logging for an Incremental Replication Subscription
- Article # SQV00DR016
This document explains how to enable logging at the level recommended by StarQuest Technical Support, and how to collect the log data after the error condition has been captured. - Transferring Control Database Information to Files
- Article # SQV00DR003
This document provides instructions for transferring the contents of an SQDR control database to files. This information can help StarQuest support engineers troubleshoot problems with a particular installation of SQDR. - Troubleshooting Replicator Service Exceptions
- Article # SQV00DR012
This technical document describes how to enable the Replicator Service to take advantage of the Windows dump facility to capture detailed information about the conditions that may be causing a failure. - Collecting Information for StarQuest Technical Support
- Article # SQV00DR009
If you experience a problem with the StarQuest Data Replicator, use the following guide to collect diagnostic data to provide to a StarQuest Technical Support Engineer.