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 process below will help migrate the solution tables properly:

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

2. Data tables were created in the OneStream Development Application during the solution installation.  Copy the data from the tables to the Production Microsoft SQL Server Database using the Microsoft SQL Migration Utility.  This utility should only be run by the Microsoft SQL Administrator.  

   The Microsoft SQL Migration Utility and instructions on its use can be downloaded online from:  https://sqlazuremw.codeplex.com

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