Separate databases

Riverbird requires existing customers who have previously used c-entron and the RMM system on the same SQL database require a mandatory separation of the databases. The reason for this is that future updates to the RMM installation can only be reliably performed on a standalone Riverbird database.

These instructions are intended for administrators and system integration partners who wish to perform the separation themselves. For more complex environments or if you have any questions, we recommend scheduling a consultation with our technical consulting team.

Back up the database

1. Open the SQL Server Management Studio (SSMS).

2. Create a Backup the desired database.
   Tip: Save the .bak file in an easily accessible location, such as C:\ or C:\TEMP.

Restore database

1. Select a database

1. In SSMS, click the Right-click on "Databases".

2. Select "Restore Database" from the context menu.

3. In the following dialog box, you can select the .bak file from the C:\Temp folder.

4. Click on “Add”to select the file for restoration.

2. Rename the database

1. Go to the tab "Files".

2. Under "Restore as," click “Search for database files”.

3. Customize the names of the database files as follows:

4. • RiverBird

   • RiverBird_Log

Configure Web Service

1. Store the login credentials for the new database in the Web Service.

Customize settings in River Suite

The first time an administrator logs in, River Suite asks for the Master Key.
This was issued when the system was first set up and should have been kept in a safe place.

1. Enter the master key

• When you log in for the first time, enter your existing master key.

• Use the same key as in the previous version.

2. Configure interfaces for c-entron

1. In the River Suite, go to the Settings → Interfaces → c-entron.

2. Select the option "Synchronize clients from c-entron".
   

   

3. Customize permissions for the RMMSystemuser

1. Open in the tab Inventory the Group and Rights Management.

2. The user RMMSystemuser requires the following permissions:

3. • Delete, create, or edit customers

   • Create and edit contacts
     
     

     

Next, you still need to Riverbird Cleanup Script for a c-entron database be carried out.

Note on Synchronization

• The first dubbing occurs automatically at 12:00 a.m..

• After that, the synchronization every hour carried out.

Note on Adjustments

• Manual cleanup is not necessary at this time.

• This will take place at a later date automatically via an update.

_{Keywords (internal): Database cleanup, cleanup, database partitioning, database partition}