Prepare a SQL database for OMPM
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
At a command prompt, navigate to the folder where OMPM is installed, and navigate to the Database folder.
CreateDB.bat <ComputerName>\<SQLServerName> <DatabaseName>
The parameters for CreateDB.bat are as follows:
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:
CreateDB.bat COMPUTER1\SQLEXPRESS OMPM001
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.