Creating Database

To create a SQL Server database manually, you can use the SQL Server Management Studio:

  1. Open SQL Server Management Studio.
  2. Right-click Databases and select New Database. The New Database screen is displayed.
  3. On the General tab, specify this information:
    Database Name
    The unique identifier for the database.
  4. On the Options tab, specify this information:
    Collation
    Select any collation which is case insensitive (CI) and accent insensitive (AI) since Expense Management is case insensitive and accent insensitive. For example: Latin1_General_100_CI_AI.
  5. Click OK. A new database is created with the name specified under databases.
    Note:  Refer to the vendor documentation on how to create databases for Oracle.