MDF repair software to repair corrupted mdf file and recover table,
views, stored procedures, rules and triggers from MS SQL Server

Replication is a set of powerful technologies to copy and distribute data and database objects among several databases and then synchronizing those databases for maintaining consistency. Using this method, you can distribute data to several different locations.

SQL Server 2005 has a wide range of features and replication characteristic is the best one among them. But this feature has some limitations and you need to apply some workarounds to emulate the missing functionality. Replication Management Objects (RMO) is a method for achieving the same goal.

Replication Management Objects is a supervised code assembly which encapsulates the replication functionalities for Microsoft SQL Server. All of the replications tasks, which you could do using the MS SQL Server Management Studio, could also be done programmatically with the help of RMO.

Replication Management Objects is designed for programming all characteristics of MS SQL Server replication. The Replication Management Objects namespace is Microsoft.SqlServer.Replication, and it is applied by Microsoft.SqlServer.Rmo.dll, which is the Microsoft .NET Framework assembly.

Microsoft.SqlServer.Replication.dll assembly, also belongs to Microsoft.SqlServer.Replication namespace, applies a managed code line for programming various replication agents (Merge Agent, Distribution Agent and Snapshot Agent).

The classes of this namespace could be accessed from RMO for synchronizing subscriptions. The classes in Microsoft.SqlServer.Replication.BusinessLogicSupport namespace, applied by Microsft.SqlServer.Replication.BusinessLogicSupport.dll assembly, are used for creating custom business logic for the merge replication. It is independent from Replication Management Objects.

To influence the capabilities exposed through RMO, you could use Visual Basic 2005 Express Edition. Once you have got it installed and running, launch the new project, based on Console Application template. To access the classes built in RMO, you need to make your project aware of their individual libraries.

The simplest way to apply RMO is to use Add Reference dialog box. From its .NET tab, select Microsoft.SqlServer.Replication .NET Programming interface, Replication Agent Library items and Microsoft.SqlServer.ConnectionInfo and click Ok button for confirming the selection. At this point of time, you can also add relevant code to the default module1.

In this way, using Replication Management Objects in SQL Server 2005, you can automate the replication process and can make your data completely safe from any of the forthcoming data loss disasters.