Copy Data from SQLite to InterBase Automatically

1. Launch Advanced ETL Processor

• Create a SQLite Connection by pointing to your .sqlite or .db file
• Create an InterBase Connection with the database path, host if remote, username, and password

2. Create a New Transformation

Right-click a transformation group and choose New to create the copy workflow.

3. Configure Reader

• Double-click the reader component to open Reader Properties
• Select your SQLite connection
• Choose the source table or use a custom SQL query

4. Configure Writer

• Double-click the writer component to open Writer Properties
• Select your InterBase connection
• Choose the target table and define the write mode: append, replace, or truncate

5. Map and Format Fields

• Map SQLite fields to InterBase columns
• Check text lengths, numeric precision, dates, and null handling
• Run a small sample first, because ten awkward rows are easier to fix than ten million

6. Run the Transformation

Click the Run button (Green Arrow). Advanced ETL Processor copies SQLite rows into InterBase and records the run in the execution log.