Copy Data from Firebird to SQL Server Automatically

1. Launch Advanced ETL Processor

• Create a Firebird/InterBase Connection by specifying the database file path, hostname (if remote), username, and password
• Create a SQL Server Connection using hostname, port, database name, username, and password

2. Create a New Transformation

Right-click on a transformation group and select New to create a new workflow.

3. Configure Reader

• Double-click the reader object
• Select the Firebird/InterBase connection
• Choose a source table or enter a custom SQL SELECT query

4. Configure Writer

• Double-click the writer object
• Select your SQL Server connection
• Choose the target schema and table
• Set the action (insert, update, or replace)

5. Map and Transform Fields

• Map Firebird fields to SQL Server columns
• Apply transformations or conversions as needed (e.g., date vs datetime2, numeric precision, Unicode/ANSI handling)

6. Run the Transformation

Click the Run button to execute the transfer. Logs will display real-time progress and any issues encountered.