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 (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.
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.