We offer SQL Server Replication support...

Support for SQL Server replication is difficult to find - as you may already have discovered! Most software companies and consultants view it as something of a black art that should be avoided at all costs.

We are one of the few UK based companies that offer support, troubleshooting and consultancy for SQL Server replication. We can help you with problems in existing replicated systems or in getting a new replicated database up and synchronising correctly.

We also design, configure and implement replicated SQL Server databases from scratch.

Some common problems

Over the years we have seen a lot of problems with SQL Server replication. Some of the commoner ones being :

• Being unable to enter data due to Primary Key conflicts.
• New records from one site overwrite existing data at another site instead of appending to it.
• Data entered at a site is subsequently deleted by the system.
• Missing data.
• Data changes unexpectedly.
• Data is visible at one site but not another.
• Download new updates but won't send changes back again.
• A user can no longer synchronise.
• Problems after a service pack or update has been applied.
• Replication works okay with small data volumes but fails with larger volumes.
• Replication works at one site but not at another.
• Replication works some of the time but not at others.
• Replication is slow.
• Problems replicating text/images.
• Problems with triggers.
• Security/firewall problems.