How to Set Up the BAM Databases Using the BAM Management Utility
Administrators typically use the BizTalk Server configuration utility to set up the BAM databases. You can use the BAM Management utility (bm.exe) as an alternate method to set up the databases.
Prerequisites
The following are prerequisites for performing the procedure in this topic:
You must have administrator permissions on the SQL server hosting the BAMPrimaryImport, BAMStarSchema, and BAMArchive databases.
To set up the SQL Notification Services databases, you must have administrator permission and be a member of the local administrators group, as well as be a member of any additional administrator groups that have been configured, such as the BTS Admins group.
You must have a BAM configuration file containing XML data from which to set up the databases.
To set up the BAM databases using the BAM Management utility
Open a command prompt as follows: Click Start, click Run, type cmd, and then click OK.
Navigate to \Program Files (x86)\Microsoft BizTalk Server <VERSION>Tracking.
Type the following at the command line prompt: bm setup-databases -ConfigFile:<configuration file>, where <configuration file> is replaced by the name of your BAM configuration file. Press ENTER.