Step 1 - Create a user

Connect to your SQL Server database as the admin and create a user for Alooma. The name of the user you create can be anything. In this example, "your_db" is the database you're syncing and "alooma" is the user being created (don't forget to provide a secure password):

Step 2 - Configure SELECT permissions

All of the objects being synced with Alooma require SELECT permission. Depending on the objects you want to sync, you will need to give your new user SELECT access to one or more of the following: database, schema, table, or column. For example, to grant the alooma user SELECT access to the entire your_db database, run this command:

You may want to grant SELECT permission to a subset of a database depending on what you're syncing with Alooma. See the Permissions section of the SQL Server documentation for more information about configuring permissions.

Step 3 - Set database compatibility

Check to see if the database compatibility for your database is greater than 90:

Step 4 - Enable Change Tracking

Enable change tracking so Alooma can avoid having to sync an entire table each time a change is made and instead just update the changed rows.

To properly configure Change Tracking, you'll need to first enable it at the database level, then enable it for each table you're syncing, and finally you'll need to grant VIEW CHANGE TRACKING permission for your user for each of those tables.