This week I'm posting an instructional video on how to use the database deployment tool.
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.
One quick question for clarification. Should SERVERNAME just be the name of the server, or the SQL instance on which you want to install? I.e. SERVER\INSTANCE or just SERVER.
If you want to put the database on a SQL Instance, then you will need to specify SERVER\INSTANCE.