Categories
More Info
Published
Markets
Languages
Database Mirroring Service
Create a read-only copy of your database to use additional reporting tools of your choice.
About this app
Tools for reporting, pattern recognition, trend processing, aggregation and another data-heavy usage, require different and more immediate access to your data than what is available through our regular online web service APIs. Standard apps in the App Store that offer dashboards, reports, and business intelligence capabilities, use this mirroring capability combined with their own offering.
If you want to use reporting tools other than those available in the App Store, or even in addition to these, you can do so by subscribing to the Database Mirroring Service here.
The Database Mirroring Service creates a read-only copy of your database and lets you store this at a chosen address/location where you can get easy access to it. The Database Mirroring Service will also keep this database continuously updated by submitting incremental changes in a predefined time interval (approx every 20 minutes as of September 2019).
The mirror is a read-only copy designed for this purpose. (It cannot be used to run local SuperOffice clients or act as an offline version of your installation).
Subscribing to Database Mirroring Service lets you create as many copies of your database as you require if you should need more than one copy of your database. Each copy is updated at the same time. The copy of your database resides at a location chosen and managed by you or your partner on your behalf.
To activate additional mirrors for your database, just click on the "Sign-up" button, and complete the form with the necessary information to set up your mirror. When everything is ready, we will activate your mirror and send it to your chosen location. Each mirror you want to use, needs to be activated here, via the App Store by completing the form telling us where you want the mirror to reside.
Key features
- The mirror is updated at 20 minutes intervals (depending on other tasks running on your database)
- Tables containing sensitive data****are not mirrored
- Resides inwhatever environment you choose to use (approved by the customer)
- Is managed by you directly or via the partner you collaborate with
- With the mirror, you can install stored procedures, indexes, run queries, and similar with the BI tools of your choice
Price information
The following price is per month and baed on a yearly subscription:
SITE
- € 71,23 per site per month.
In addition to the EURO, prices are available in NOK, SEK, DKK, GBP, and CHF.
By activating the service via the App Store, you are in effect ordering this subscription.
This add-on will be added to your current subscription plan and invoiced by your local SuperOffice company.You may also contact your local SuperOffice sales contact to order your subscription for this add-on service. Once you are subscribing to Database Mirroring Service, you can request as many copies as you require at no additional cost. Note that you need to complete and submit the form each time you want an additional copy.
TERMS & CONDITIONS
- See the terms of service for more information.
- See the terms Data Mirroring Service for more information.
Requirements
- Local of hosted Microsoft SQL Server environment.
- You must have an accessible web service that implements the IMirroringClientService contract and is available for receiving the initial database mirror and subsequent updates.
- We provide a working Microsoft SQL server example of the web service, and the documentation that thoroughly covers the capabilities and limitations of Database Mirroring. This is just an example for your convenience and not a supported product.
- The database for our example must be Microsoft SQL Server. The license for this database is not included in the service as provided from SuperOffice. A separate license is required.
- Our working example is available as a NuGet package and provided to help you get started (see the documentation link above). Note that our Database Mirroring package on NuGet.org includes performance tracking code. This collection of performance data does not contain any information about the customer or data in the database. It only tracks how long each replication action takes. The performance data is sent back to SuperOffice only to help us make future improvements.
Getting started
- Click the green button to get started.
- Complete the form to confirm your order of the subscription and to provide the necessary information we need to activate your Mirror. This includes an endpoint URL to receive the mirror database.
- Read the available information on how to set up and use the mirror by you or your partner.
- Receive the copy and begin to use as you require.
