📘
TimeLine E3
  • TimeLine E3 Documentation
  • Framework
    • Introduction
    • DataSet Definition
    • Window Handling Object
      • Input/Output arguments
      • Open
      • BindDataControls
      • Item Changes
      • Item Search
      • MenuItemClicked
      • Print
      • ModuleOpened (BlueArrow)
      • BlueArrowArguments
      • New Row
      • Delete Row
      • Save
      • Transactions
      • Locking [deprecated]
      • Locking (new)
      • Resizing a response window
      • ParaPanel
      • Adding DMS Tab to a Module
    • BusinessObject
    • Controls
      • BindingFormat
      • LookupGrid and SearchDef
      • ComboBox
      • RadioButton
      • Multiline Textbox
      • xTextBoxSearch
      • xFileBrowse [v16+]
      • DxDispoColumn
      • DxProgressColumn
      • DxTemplateColumn
      • Change control caption programmatically
      • TabControl
      • Navigation
      • Enable controls programmatically
      • Enable a MenuItem programmatically
      • Filter search values
      • Jumping to another module
      • Messages, Notifications, Log, Exceptions, Translation
      • LoggerSink [deprecated]
      • Log
      • OpenFile, FolderBrowsing and SaveFile
      • Execute Actions while displaying an Hourglass
      • Using Progress
      • Async methods with progress bar
      • Wizard
      • Customizing controls using xBehaviors
      • TLProperty.AllowInReadOnly [v16+]
    • DataSet Operations
    • Business-related functionality
      • Getting the next primary key
      • Hybrids
      • Enums
      • Get Current User
    • SQL
    • SQL (using named parameters)
    • Advanced SQL
    • Expression Binding
    • Server-side logic & customization [v16+]
      • Service Hoster
      • Starting / stopping hosted services
      • Changes to scheduled jobs!
      • Business Object Proxies
      • Business Object API
    • Colors in Expression Bindings [v15+]
    • Theming
      • Icons
  • TimeLine Developer (TLD)
    • Debugging in TLD
    • Targets
    • Custom Project Rework [v16+]
  • TimeLine-specific LL functions
  • Stunnel proxy
    • Pre-requisites
    • 1. Initial setup
    • 2. Generate the server/web certificates
    • 3.a. Generating client certificates using the CSR flow
    • 3.b. Generate client certificates from the server console
    • 4. Setting up the E3 client connection
    • 5. Setting up the browser certificates
  • Configuration
    • Configuring the WCF timeout
  • Troubleshooting the E3 Bridge
  • [Deprecated]
    • TimeLine WEB - deprecated in v16+
      • Prerequisites for running the WASM modules on the server
      • Prerequisites for developing WASM modules with TLD
      • Creating a small web module with TLD
      • Terminal Configuration
    • Customization Examples - deprecated in v16+
    • Codestore [deprecated]
    • Configuring the scheduled jobs timeout - deprecated in v16+
  • ASA to PostgreSQL Migration (V17)
    • PostgreSQL Setup
    • TimeLine Migration Tools
      • SQL Transpiler
      • DataSet Migration
    • ASA17 vs PostgreSQL Syntax differences
    • Alias referencing
    • In-Line SQL Statements
Powered by GitBook
On this page
  1. ASA to PostgreSQL Migration (V17)
  2. TimeLine Migration Tools

DataSet Migration

PreviousSQL TranspilerNextASA17 vs PostgreSQL Syntax differences

Last updated 1 day ago

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

  1. Open the table in SQL Designer

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

  1. Test the generated statement by pressing Test

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

  1. Fix the issue and press "Test" again

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

  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

Error on Dataset Preview in TimeLine Developer
Generated PostgreSQL Statement with Dataset Designer
Test generated PostgreSQL statement with Dataset Designer
The cursor will be placed at the offset that generates the error
Highlighted first fix. After pressing on "Test", second error is displayed
Highlighted second fix. Pressing on "Test" opens Dataset Previewer