Chapter 6: Managing Application Catalog Databases
Sharing Application Catalog Data
294
ADS-0950-UG00
AdminStudio 9.5 User Guide
Using Microsoft SQL Server to Perform Merge
Replication of Application Catalogs
AdminStudio supports merge replication of Application Catalog databases using Microsoft SQL Server 2005. You
can use merge replication to synchronize Application Catalog databases distributed in multiple locations across a
large enterprise, ensuring that all databases are kept up-to-date. One location can publish software packages to IT
teams at other sites, keeping all teams current while enabling each to manage their software independently.
To set up merge replication, first you use the AdminStudio interface to create an Application Catalog to serve as a
Publisher database. You then use SQL Server Management Studio to configure this database as a Publisher, by
creating a Publication. Lastly, you use SQL Server Management Studio to create one or more Subscriptions (and
Subscriber databases).
Perform the following steps to implement merge replication of AdminStudio Application Catalogs:
•
Step 1: Creating the Publisher Database
•
Step 2: Generating the Publication Script for the Publisher Database
•
Step 3: Creating the Publication (Running the Script)
•
Step 4: Creating a Subscription and a Subscribing Database
•
Step 5: Starting the Snapshot Agent
•
Step 6: Verifying the Existence and Integrity of the Subscriber Database:
Step 1: Creating the Publisher Database
To create the Publisher database, perform the following steps;
Task:
To create the Publisher database:
1.
Open AdminStudio and create a new AdminStudio Application Catalog on an SQL Server 2005 database
server, such as the AdminStudio Application Catalog database server).
2.
Close AdminStudio, and verify in SQL Server Explorer/Management Studio the existence of the newly created
database.
Summary of Contents for ADMINSTUDIO 9.5
Page 1: ...AdminStudio 9 5 User Guide Version 9 5...
Page 50: ...Contents 50 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 52: ...52 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 156: ...156 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 440: ...440 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1090: ...1090 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1426: ...1426 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1686: ...1686 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1794: ...Chapter 24 AdminStudio Public API Reference 1794 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1842: ...Index 1842 ADS 0950 UG00 AdminStudio 9 5 User Guide...
