Create the EFM Buffer Database

An empty EFM buffer database must be created before configuring the application. Typically, this is called EFM but you may choose a different name. If a different name is chosen, you will need to update the BufferDatabase configuration in ACMSettings.json. For more information, see Configure ACMsettings.json.

1. Open Microsoft SQL Server Management Studio and connect to the database instance on the server that will be running the data connector service.

2. Use the following command to create the database, setting the file name, file path, database size, maxsize and filegrowth as required:

   use master

   go

   create database EFM

   on primary

   (name= EFM,

   filename= 'C:\Program Files\Microsoft SQL Server\MSSQL16.OASYSHDB\MSSQL\DATA\EFM.mdf',

   size= 1GB,

   maxsize = UNLIMITED,

   filegrowth = 64MB)

   log on

   (name = 'efm_log',

   filename = 'C:\Program Files\Microsoft SQL Server\MSSQL16.OASYSHDB\MSSQL\DATA\EFM_log.ldf',

   size = 500MB,

   maxsize = 1GB,

   filegrowth = 64MB)

   go