User Guide Home   >   Syncrify Server   >   Manage Users via RDBMS



Manage Users via RDBMS

By default, Syncrify does not require any database. It stores everything in local files, most of them are in XML format. Often, companies (particularly service providers) have thousands of users and they want to maintain the users in Syncrify programatically.


Important: This feature is only available in Syncrify's ISP Edition.




Consider This Scenario

Most ISPs have their own website where they offer other services besides remote backup. By storing the user information in a database, information can be modified in realtime without using Syncrify's web interface.

rdbms1

Here are some pros and cons of using a relational database.



Advantages



Disadvantages



Prerequisites

At this time, Syncrify supports two database Vendor:

  1. MySQL
  2. MS SQL Server

You must have one of the above RDBMS installed either on the same machine or a different machine. You will need a valid user account on the back-end with the following permissions:

Syncrify stores user records in just one table called synusers. If this table does not exist, it will be created when you enable RDBMS in Syncrify.



Configuration

Follow the steps below to configure database.