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.
I have MR2.0.1700.66 on a windows 2003 server. I loaded the console from the MR012CU8 install. I followed your video exactly using the windows 2008 terminal server that hosts the GP2010 client. These were the results: The database deployment failed: with the words "could not deploy package". I have tried to locate more information on this subject - but the link you provided did not have any documents that contained a section called "Install Management Reporter 2012 on Windows Server 2003" At any rate, any advice on how to proceed with this initiative would be greatly appreciated.