Copy Data from SQL Server to MySQL Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection with server name, database name, and authentication details
• Create a MySQL Connection by entering the host, port, database name, username, and password

2. Create a New Transformation

Right-click a transformation group and choose New to begin defining your data flow.

3. Configure Reader

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

4. Configure Writer

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

5. Map and Format Fields

• Match fields from SQL Server to MySQL columns
• Apply transformations or type conversions if needed

6. Run the Transformation

Click the Run button (Green Arrow) to copy data from SQL Server to MySQL. The entire process is logged, with error handling and rollback options included.