Generating SQL Scripts

You can generate SQL scripts from which you can manually create a repository. When you save the scripts, you are not required to provide repository connection information.

  To generate SQL scripts:

  1. Click the Repository Wizard.

  2. Select Generate SQL scripts and click Next.

  3. Select the Oracle or SQL Server tab and enter repository information.

  4. Click Next.

  5. On the Repository Creation Script screen, click Save to File and navigate to a folder in which to save the file.

    Note:

    The file name for both Oracle and SQL Server databases is drm-create-database.sql.

  6. Click Next.

  7. On the Repository Object Creation Script screen, click Save to File and navigate to a folder in which to save the drm-create-schema-objects.sql file.

  8. Click Next.

  9. Click Finish.