Export (0) Print
Expand All

Prepare a SQL database for OMPM

Office 2007

Updated: November 16, 2006

Applies To: Office Resource Kit

 

Topic Last Modified: 2008-08-11

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:

    CreateDB.bat <ComputerName>\<SQLServerName> <DatabaseName>
    

The parameters for CreateDB.bat are as follows:

 

Parameter Description

ComputerName

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

SQLServerName

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

DatabaseName

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:

CreateDB.bat COMPUTER1\SQLEXPRESS OMPM001

Notes:

  • You must have Database Operator permissions to run this script.

  • To obtain help for this command, at a command prompt, type createdb.bat /?.

  • Multiple databases can exist on the same server.

  • DeleteDB.bat is an additional command-line utility included with OMPM that allows a user to delete a database.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft