Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

How to use the database deployment tool for Windows 2003

How to use the database deployment tool for Windows 2003

Rate This
  • Comments 2

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.

  • It is required to create a new Management Reporter or data mart database.
  • It is required to perform any incremental updates to the Management Reporter database when new rollups are released.  
  • It is not required if you are running Management Reporter on Windows 2008, Windows 2008 R2, or Windows Server 2012 machine . If you are on a newer version of Windows Server you can stop reading now as this information does not apply to you.

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.

  • If you have installed Management Reporter 2012 Rollup 2 the database deployment tool is on your server.
  • If you are still on the RTM or Rollup 1 release of Management Reporter you do not yet have the tool. It will be required to update your Management Reporter database to 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:

            MRDatabaseDeploy.exe /?

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

            /databasename:ManagementReporter /databasecollation:SQL_Latin1_General_CP1_CI_AS

            /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.

 

 

Leave a Comment
  • Please add 3 and 1 and type the answer here:
  • Post
  • 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.

Page 1 of 1 (2 items)