Documentation Center

Creating an SDL Contenta S1000D database

After installing SDL Contenta S1000D, import an SDL Contenta S1000D database that contains all the appropriate object types and structure, but no content.

Before you begin

Ensure that SDL Contenta is installed and functioning correctly.

Procedure

  1. Copy the appropriate s1000d.dmp from the following location to a temporary directory.
    Database VendorPath
    OracleContenta_home/S1000D_samples/databases/Contenta56_Oracle11g_database or

    Contenta_home/S1000D_samples/databases/Contenta56_Oracle12c_database

    MS SQL ServerContenta_home/S1000D_samples/databases/Contenta56_MSSQLServer_database

    For Oracle, the temporary directory must be on a system that has pcmadmin installed. For MS SQL Server, the temporary directory must be on the MS SQL Server system.

  2. At a command prompt, enter the appropriate command.
    Database VendorCommand
    Oracledbimport.pl -dbase dbase@sid -i "tempdir"
    MS SQL Serverdbimport.pl -dbase dbase -i "tempdir"
    Database VendorCommand-line optionDescription
    Oracle-dbaseName and Oracle SID of the new database.
    -iDirectory path and filename where the s1000d.dmp file is located.

    Enclose in quotation marks.

    MS SQL Server-dbaseName of the new database.
    -iDirectory path and filename where the s1000d.dmp file is located.

    Enclose in quotation marks.

    For more information on command-line options for the Database Import Command, refer to the SDL Contenta Administration User documentation, Database Maintenance Commands section.

What to do next

Now that you have a Contenta S1000D database, modify the default AppData values as needed in the database. See Modifying AppData settings after installing or upgrading Contenta S1000D.