A repository containing a sample database mirroring project.
This project is a sample based on the article from the docs site Getting Started With Database Mirroring.
Database mirroring will not replicate all tables. The service skips unnecessary tables containing only configuration and/or sensitive information. A complete list of skipped tables is discussed in the article mentioned above.
To include more tables to skip, the table names must be added to a SkipTable user preference. To read more about that, please read the skip mirroring tables article.
-
Must be an online customer with an active tenant in the production environment, or have a sandbox tenant in the SuperOffice online development environment. To get a sandbox environment, register a SuperOffice online developer account.
-
Must have a registered application in SuperOffice Developer Portal.
-
Destination database server must be SQL Server.
-
Application must be published.
-
This Server hosting IIS must have installed SuperOffice online certificates in accordance with the installation procedures. Use the correct certificates based on the target environment (development, stage and production).
| Name | Value |
|---|---|
| SoAppId | ApplicationID / ClientId |
| SoFederationGateway | SuperID login URL |
| SuperIdCertificate | Thumbprint of certificate (different per environment) |
| MirrorDatabaseName | Name of destination database |
| ConnectionBase | Database connection string |
| PrivateKeyFile | Filename containing applications private XML RSA key |
| EnableLogging | Determines if a log file is written to the Temp dir. |
Questions should be asked on the community developer forums.
Any bugs or issues observed should be added here under the issues tab.