This blog communicates with customers, partners, and the Dynamics community about the exciting developments related to CPM (Management Reporter, Forecaster and Enterprise Reporting) across all of the Microsoft Dynamics ERPs.
This week I wanted to post an instructional video on how to use the database deployment tool. I've seen a bit of confusion and thought a tutorial would be helpful.
Why would I use the database deployment tool?
The database deployment tool was created to support those that need to run the Management Reporter services from a Windows 2003 machine.
Do I have access to this tool now?
The database deployment tool was released with Management Reporter 2012 Rollup 2 and is included in any release with Rollup 2 or newer.
Where can I get more information on the database deployment tool?
The full documentation is available in the Installation and Configuration guide (MRforDynERPInstGuide_ENUS.pdf) on the Microsoft Download center here. The steps are under "Install Management Reporter 2012 on Windows Server 2003".
How can I get a list of the available parameters?
Run the following to get a list of available parameters:
Can you provide an example of the syntax needed to deploy a new Management Reporter database?
Below is an example of the syntax to deploy a new ManagementReporter database to a remote machine named SQLServer
MRDatabaseDeploy.exe /action:create /databasetype:ManagementReporter /servername:SQLServer
/databasemasterkey:pass@word1 /servicedomainuser:contoso\mr_svc /adminuser:contoso\ryan
Note: This should be a single line of text with just spaces with parameters between each switch. I broke this into three lines to avoid the text being cut off.
(Please visit the site to view this video)
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics