From version 3.0 of Integration Manager the tool has fully support to automatically deploy new log databases. The new log databases will be deployed depending on two system parameters

  • DaysToSplitDatabaseOn: The number of days after which new IM Log databases should be created on.
  • SizeToSplitDatabaseOn: The maximum size (in GB) the current log database should have until a new IM Log database should be created.

If this is not the case, that means if Integration Manager does not manage to create a new database it might be useful to know how to deploy a new database.

Prerequisites (the packages below need to be installed on the machine from which the database will deployed from to the target SQL server)
  • Microsoft SQL Server Transact-SQL ScriptDom (SqlDom.msi)
  • Data Tier Application Framework (DACFramework.msi)
  • Microsoft SQL Server System CLR Types (SQLSysClrTypes.msi)
You can find all the requisites attached to this solution, both 32-bit and 64-bit versions.

As soon as you have installed the different MSI packages you will now be able to deploy a new log database. 

Please follow the steps below in order to deploy new log databases:
  1. Open Command Prompt as Administrator (Make sure the account you are using has db_creator rights on the target SQL server.
  2. Please locate the SqlPackage.exe (this file is usually in the following folder (C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe - you can see in the path that there is a SQL version defined, please verify that you are in the correct folder, it either must be 110 or higher - if there is an higher version, is it!)
  3. Use the command prompt and navigate in the folder where the SqlPackage.exe is located: cd "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\"
  4. Press Enter
  5. Please write the following line into the command prompt to create the new log database: SqlPackage.exe /Action:Publish /TargetServerName:servername /TargetDatabaseName:databasename /SourceFile:PathToIMLog.dacpac
    Please replace 
    1. servername = The name of the SQL Server
    2. databasename = The name of the logging database
    3. PathToIMLog.dacpac = The location if the imlog.dacpac file. This file is located in {IntegrationManagerInstallationFolder}/Databases/IMLog.dacpac
  6. Press Enter
  7. If everything works as it should, the new log database is created.
  8. Add the newly added database to Integration Manager via the web interface under "Administration" -> "Log" -> "Log Databases".
  9. Done