Replication Tools (Enterprise Manager)

Microsoft® SQL Server™ 2000 provides several methods for implementing and administering replication, including SQL Server Enterprise Manager, programming interfaces, and other Microsoft Windows® components.

SQL Server Enterprise Manager includes a graphical organization of replication objects, several wizards, and dialog boxes you can use to simplify configuration and administration of replication. SQL Server Enterprise Manager allows you to view and modify the properties of replication configuration and monitor and troubleshoot replication activity.

You can also implement, monitor and maintain replication using programming interfaces such as Microsoft ActiveX® controls for replication, SQL-DMO, and scripting of Transact-SQL system stored procedures.

Components such as Windows Synchronization Manager and Microsoft Windows 2000 Active Directory™ Services enable you to synchronize data, subscribe to publications, and organize and access replication objects from within Windows applications.