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