Starquest Customer Support

SQDR FAQ: Article # SQV00DR006
This article answers frequently asked questions (FAQs) about the StarQuest Data Replicator (SQDR).

SQDR Quick Start Guide (PDF): Article # SQV00DR001
This document is a guide for installing and configuring the StarQuest Data Replicator. It is available in PDF format so you can print the document for easy reference to the information as you install and configure the Data Replicator software.
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.
Cloning SQDR Subscriptions: Article # SQV00DR0011
This document provides instructions on how to successfully clone subscriptions from one SQDR 3.x system to an SQDR 3.x installation on a different system.
Upgrading from a Prior Release of SQDR: Article # SQV00DR005
This document demonstrates how to upgrade from a prior release of SQDR. These instructions were taken from the Introduction chapter of the StarQuest Data Replicator Help. Please read the entire document before upgrading.

Using SQDR for Limited Incremental Replication from SQL Server: Article # SQV00DR0017
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 # SQV00DR0018
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 # SQV00DR0010
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 # SQV00DR0013
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 # SQV00DR0014
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 # SQV00DR0015
This document explains how to schedule the execution of this script using the Windows Scheduled Tasks facility.

How to Enable SQDR Logging for an Incremental Replication Subscription: Article # SQV00DR0016
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 # SQV00DR0012
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.

StarQuest Data Replicator Technical Documents