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