How Can I Upgrade the SQL Server Binary Log Reader DLL Using PowerShell?

Question

How do I upgrade the SQL Server Binary Log Reader DLL using PowerShell?

Environment

• Connector: SQL Server
• Incremental sync method: Binary Log Reader

Answer

To upgrade the SQL Server Binary Log Reader DLL:

1. Confirm that you have administrator access on your SQL Server host.
2. In Fivetran, go to Account Settings > Downloads, then download the following files:
   • The BinLogInstall.ps1 PowerShell script.
   • The latest Fivetran SQL Server Binary Log Reader DLL ZIP file.
3. Extract the DLL, for example, Fivetran-Log-Data-<version>.dll, and copy it to your SQL Server host.
4. Make a note of the full directory path to the DLL file. For example, C:\MSSQL-CLR.
5. Pause all SQL Server connections that use the SQL Server Binary Log Reader. Otherwise, the script may temporarily interrupt their syncs.
6. Open PowerShell as an administrator and run the following command, replacing the placeholders with your actual database values:

   .\BinLogInstall.ps1 -SqlInstance <instance> -SourceDatabase <database> -SqlAdminUser <admin_user> -SqlPassword <password> -Reinstall -DLLPath <path_to_new_DLL>
   

   • -SqlInstance: The full SQL Server instance name. For example, <ServerName>\<InstanceName>.
   • -SourceDatabase: The database where the DLL is installed. This parameter replaces the deprecated -TargetDatabase parameter.
   • -DLLPath: The directory containing the new DLL, excluding the filename. For example, C:\MSSQL-CLR.
7. After the script completes successfully, resume the paused connections.