Replication Schema Parser

The Replication Schema Options Parser converts @schema_option arguments for replicated articles back and forth between human readable options and the bitmaps used by various versions and types of SQL Server Replication.

Instructions

I tried to make the tool as simple to use as possible. Just fire it up, select the version and type of replication you're using, paste an existing @schema_option argument (or bitmap) into the appropriate field and the bitmap will be 'translated' into a list of checkboxes - showing which options are selected or not.

You can then modify the selected options and push the "Convert Selected Options to BitMap" button and your selected options will be converted into a bitmap (in the Schema_Option field) that can be used as the @schema_option argument for sprocs used to add/modify articles in your publications.

More information on the genesis of this tool can be found on my Practical SQL Server blog.

Works With...

Currently, the Replication Schema Options Parser supports the following versions of SQL Server:

• SQL Server 2000
• SQL Server 2005
• SQL Server 2008
• SQL Server 2008 R2

And provides support for the following replication stored procedures:

• sp_addarticle (Transaction/Snapshot Replication)
• sp_addmergearticle (Merge Replication)

Which means that this tool supports:

• Snapshot Replication Schema Options
• Transactional Replication Schema Options
• Merge Replication Schema Options

Download / Install

The Replication Schema Options Parser is 100% free, requires the .NET 4.0 Framework and does not require installation.

Contact

This tool is a work in progress, and isn't 'officially' supported. But I want it to work as advertised, so contact me if you have any questions, problems, or ideas on ways to make it better.

Tools Home