Solution Database Migration Advice

A Development OneStream Application is the safest method for building out a solution with custom tables such as this one. The relationship between OneStream objects such as Workflow Profiles and custom solution tables is that they point to the underlying identifier numbers and not the object names as seen in the user interface. Prior to the solution configuration and to ensure the identifiers match within the Development and Production Applications, the Development Application should be a recent copy of the Production Application. Once the Development Application is created, install the solution and begin design. The following process below will help migrate the solution tables properly.

See also: Managing a OneStream Environment in the Design and Reference Guide

1. In the Production OneStream application, install the solution and create the data tables. See Configure the OneStream Application Server for Database Server Connection settings and installation details.

2. Data tables are created in the OneStream Development application during the solution installation. Using the Microsoft Data Migration Assistant, copy the data from the tables to the Production Microsoft SQL Server Database. Only the Microsoft SQL Administrator should run the migration assistant.

IMPORTANT: This process has the potential to overwrite existing table data in the Production application database if data already exists.