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

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

Type:

	Copy Code
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:

	Copy Code
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.

Download this book

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

Planning and architecture for the 2007 Office release

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