Prepare a SQL database for OMPM
Updated: November 16, 2006
Applies To: Office Resource Kit
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
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 (https://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:
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.
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.