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.
- Copy the downloaded script to the database server and extract it.
- 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;