Setting Up Database Replication in SQL Server
Create publications and subscriptions for iBase.
- Entity and link data from the main iBase database
- Security data (this can be shared by several iBase databases)
- Audit data
- Suitable procedures for creating publications and subscriptions are described in the following
section. Unless stated otherwise, the procedures are the same for all supported versions of SQL
For the main iBase database that contains the entity and link data, you publish all the user tables and a specified set of iBase system tables. You do not publish any user-defined stored procedures or views. The procedure is slightly more complicated when the initial snapshot for the main database is too large to download over a communication link. For details of the deployment process used in this situation, see:
- Overview for Large Databases
For background information on the SQL Server options supported by iBase, see Overview of Supported SQL Server Replication Features.