SQL Replication Test Tool Version 4.2

SQL Replication Test Tool version 4.2

Updated Date: 11/15/2006

Description

The SQL Replication Test Tool is designed to troubleshoot issues with SQL Immediate Updating Transactional Replication.

Installing the SQL Replication Test Tool

Create a stored procedure on the IMA subscriber database by running the DSRepCheck stored procedure.

How To Use the SQL Replication Test Tool

Note: Remember to back up the database before running any database utilities.

Running the tool through Query Analyzer:

Connect to the subscriber database as the IMA user account.
Set the results to text in the SQL Server Management Studio. Refer to the following screen shot:

Issue the following command:

dsrepcheck <publisher_sql>,<publisher_database>

Where <publisher_sql>, is the name of the SQL server acting as the publisher and <publisher_database> is the name of the published database on the publisher. Refer to the following screen shot:

Using a script:

Create a file called sql.txt with the following SQL statements from the example caller script contained in the .zip file attached to this article (CallerScript for DSRepCheck 4.1.txt).
Issue the following command to execute the script through the command line:

Osql –S <> -U sa –P citrix –I c:\sql.txt >> out.txt

Disclaimer

This software application is provided to you “AS IS” with no representations, warranties or conditions of any kind. You may use and distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER, EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NONINFRINGEMENT. Without limiting the generality of the foregoing, you acknowledge and agree that (a) the software application may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the software application fully functional; and (c) Citrix may, without notice or liability to you, cease to make available the current version and/or any future versions of the software application. In no event should the code be used to support of ultra-hazardous activities, including but not limited to life support or blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY DAMAGES WHATSOEVER ARISING FROM USE OF THE SOFTWARE APPLICATION, INCLUDING WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. You agree to indemnify and defend Citrix against any and all claims arising from your use, modification or distribution of the code.