DataSet Migration

Please ensure that BOTH Timeline Developer and Timeline Server are version V17 from 29.05.2025 or later.

We recommend performing a clean install on all TimeLine products before starting the dataset migration.

1. Open TimeLine Developer and load your TimeLine Solution

2. Go to the Resources Tab, on the Datasets folder

3. Select the dataset you want to migrate and open it in Dataset Designer

4. Click on Dataset Preview. If you get errors, this dataset needs to be migrated manually

Error on Dataset Preview in TimeLine Developer

1. Open the table in SQL Designer

2. Navigate to the PostgreSQL tab, click on "Generate"

Generated PostgreSQL Statement with Dataset Designer

1. Test the generated statement by pressing Test

Test generated PostgreSQL statement with Dataset Designer

1. By clicking on "Ok," TimeLine Developer will focus on the line and offset that generates errors. This will need to be fixed manually

The cursor will be placed at the offset that generates the error

1. Fix the issue and press "Test" again

Highlighted first fix. After pressing on "Test", second error is displayed

1. Resolve any remaining issues individually until the "Test" button successfully opens the Dataset Previewer

Highlighted second fix. Pressing on "Test" opens Dataset Previewer

When the SQL statement on the PostgreSQL Tab is validated, it indicates a valid version has been achieved. Please note that these changes must be made manually in specific sections of the Dataset Designer (i.e. SQL Computed, Where, etc.) ; otherwise, they will be lost. The content on the PostgreSQL Tab will not be saved in the dataset.

Adjusting the WHERE clause in a dataset after successfully passing the "Test" validation.

1. Once you fix the first table, click "Preview" on the dataset. If the Dataset Preview works, it means the dataset is compatible with PostgreSQL. If not, repeat steps 1-10 for each dataset table