Deploy the EFM Buffer Data-Tier Application Package (DACPAC)

Start an elevated PowerShell session.

Execute the following commands, replacing the <SQL Server Name> with your computer's information:

Set-Location “C:\Program Files\Microsoft SQL Server\160\DAC\bin”

.\SqlPackage.exe /a:Publish /sf:$env:DNADataRoot\CloudData\config\DacpacTemplate\dacpac\ACMdacpac.dacpac /tdn:EFM /tsn:<SQL Server Name> /ttsc:True /p:RegisterDataTierApplication=True /p:BlockWhenDriftDetected=False

Note: The command provided is an example. Ensure you replace <SQL Server Name> with the name of your Microsoft SQL Server.

After installing the DACPAC, confirm a successful installation by checking to see that the stored procedures have been created in the on-premises Microsoft SQL Server instance for the EFM buffer database. The tables should already exist, so the stored procedures will be what is newly created.

Continue to AVEVA Measurement Advisor Settings that Impact the Data Transfer.