Subscriptions for restored databases
This procedure only applies to systems where the initial snapshot is transferred manually using a full backup.
Before you begin
You need to restore the iBase entity and link data if you chose to transfer the initial snapshot of data to the subscriber site by using a full backup. Your iBase administrator should have already created an empty iBase database to receive the data.
- Turn on Overwrite the existing database
- Leave Preserve the replication settings turned off
- Start a new subscription, either a push subscription or a named pull
Option Description Publication The database that contains the iBase entity and link data at the Publisher. Subscription database The existing entity and link database at the Subscriber.Select the following options for the subscription:
- The Subscriber does not have the schema and data and should therefore be initialized.
- The Merge Agent should continuously check for updates.
- Use the Publisher as a proxy for the Subscriber when resolving conflicts (described as First to Publisher Wins).
- The subscription is a client subscription type
- Synchronize each Subscriber with the Publisher:
- If the Merge Agent is set to use On Demand synchronization, start the Merge Agent
manually to upload any changes from the Publisher.Note: If there has been many changes at the Publisher, you might want to delay this step until there is a quiet period on your communications link.
- Check whether you are synchronized with the Publisher by verifying that a recent change in one of the user tables at the Publisher is replicated to the Subscriber.
- If the Merge Agent is set to use On Demand synchronization, start the Merge Agent manually to upload any changes from the Publisher.
- Set the Merge Agent for the Subscriber to run at the required frequency, for example a polling interval of 1 second.
- Verify that the snapshot has been applied by checking that a rowguid column exists in one of the user tables selected for the article. If this column is missing, check that the snapshot has been applied.
- Test that replication is working correctly for the new subscription. Use one of the
- At the Publisher, in one of the user tables (table names do not start with an underscore), change the data in one of the columns for a row. For a new database, carry out this test on the _GlobalConfiguration table and change the version number but take care to change it back to its original value.
- After the change is replicated, check the corresponding table at the Subscriber.
- At the Subscriber, change the column back to its original value.
- After the change is replicated, check the table at the Publisher. If the Subscriber is supposed to be read-only, and the change is merged at the Publisher, check the setting of the Merge Agent.
- If the Subscriber is read-only, change the data at the Publisher back to its initial value.
- Restrict access to the tables in the SQL Server database. See the Administration Center document Managing Access Control, for details. The information in this document applies to all types of iBase database.
- Back up the databases.
- Tell the iBase administrator that the security data at the Subscriber is configured for replication.