Copy Data from SQL Server to PostgreSQL Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection using server name, database name, authentication type, and credentials
• Create a PostgreSQL Connection with host, port, database name, username, and password

2. Create a New Transformation

Right-click on a transformation group and choose New to define a new workflow.

3. Configure Reader

• Double-click the reader component to open Reader Properties
• Select your SQL Server connection
• Choose a table or write a custom SQL SELECT query

4. Configure Writer

• Double-click the writer component to open Writer Properties
• Select the PostgreSQL connection
• Specify the target table and insert mode (append, truncate, replace)

5. Map and Format Fields

• Map SQL Server fields to PostgreSQL columns
• Apply necessary transformations or data type conversions

6. Run the Transformation

Click the Run button (Green Arrow). The data will be copied from SQL Server to PostgreSQL with logging, rollback, and error-handling features active.