Updated: 2006-11-16

You can use SQL Server to create a database for use with OMPM. You can also use SQL Server 2005 Express Edition as your database server. SQL Server 2005 Express Edition is available as a download from SQL Server 2005 Express Edition (http://go.microsoft.com/fwlink/?LinkId=95582).

To provision a SQL database

  1. At a command prompt, navigate to the folder where OMPM is installed, and navigate to the Database folder.

  2. Type:

      CopyCode imageCopy Code
    CreateDB.bat <ComputerName>\<SQLServerName> <DatabaseName>

The parameters for CreateDB.bat are as follows:

Parameter Description


The name of the computer that is hosting the SQL Server.


The name of the SQL Server where the new database is created. Required.


The name of the database created. Required.

For example, if your computer name is COMPUTER1, the database server is SQLEXPRESS, and your new database name will be OMPM001, type the following at the command prompt:

  CopyCode imageCopy Code


Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Office Resource Kit information.