+

Search Tips   |   Advanced Search

Database transfer: Download a script and create the MS SQL database

Manual steps from the Configuration Wizard can be found in the IBM Knowledge Center.

  1. Copy the downloaded script to the database server and extract it.

  2. Run the SQL statements listed in this script in the SQL processor.

    Example of the script created by the Configuration Wizard

    CREATE DATABASE WPSDB ON (NAME=RELDB_DATA, FILENAME='C:\\Microsoft SQL Server\\instance\\MSSQL/Data/WPSDB_Data.MDF', SIZE=10MB, MAXSIZE=UNLIMITED, FILEGROWTH=5MB)
    LOG ON (NAME=DB_LOG, FILENAME='C:\\Microsoft SQL Server\\instance\\MSSQL/Data/WPSDB_Log.LDF', SIZE=100MB, MAXSIZE=30000MB, FILEGROWTH=100MB)
    collate SQL_Latin1_General_CP1_CS_AS
    ;
    ALTER DATABASE WPSDB SET READ_COMMITTED_SNAPSHOT ON;


Parent Manual Steps: Database Transfer