Chapter 6: Managing Application Catalog Databases
Sharing Application Catalog Data
278
ADS-0950-UG00
AdminStudio 9.5 User Guide
Note •
The
Publication Manager
and
Subscription Manager
options under
Replication
on the AdminStudio
Catalog
menu are only enabled when a user with
sysadmin
privileges on an SQL Server database server connects
to a database on that server.
•
If that database was defined as a
Publisher
when it was created, the
Publication Manager
option is
enabled.
•
If that database was defined as a
Subscriber
when it was created, the
Subscription Manager
option is
enabled.
See
Application Catalog Wizard
for information on how to identify databases as Subscribers or Publishers.
Caution •
You can create as many Subscriptions or Publications as you want to, but because any previously
replicated data is deleted whenever new Subscription data is received, the Subscriber should have only one
Subscription active at any one time. If you want to have more than one Subscription set up at one time and switch
between them, see
Using the “Disable” Feature to Subscribe to More Than One Publication
for more information.
Configuring the AdminStudio Shared Location for Replication
When Publishing data using Application Catalog Replication, the Publication Server needs access to two script
files that are installed in the AdminStudio Shared Directory Location. Therefore, the AdminStudio Shared directory
location should refer to a network folder, making it accessible to the Publication Server. See
Specifying the Shared
AdminStudio Application Catalog
.
Initial Configuration Checklist
Before you can use Application Catalog Replication, you need to perform the following steps to configure the
Subscriber and Distributor databases at your organization. If the Subscriber and Distributor databases are not
configured in this manner, Replication will fail.
Note •
The Publisher server is often configured as its own Distributor server.
Task:
To configure the Subscriber and Distributor servers:
1.
Check the SQL Server Agent logins configured on the Subscriber and Distributor databases, and make sure
that the SQL Server Agent on the Subscriber database can login to the Distributor database via the Distributor
SQL Server Agent using the
distributor_admin
login.
2.
Configure a Distributor database for the servers that are publishing data.
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...