Merge multiple similar Redshift tables to 1 SQL Server table

by

Posted on by

Want to transfer data from multiple similar Redshift tables to 1 SQL Server table?

Try Withdata DBCopier, a Redshift to SQL Server converter for Windows, Mac, and Linux, Copy Redshift data to SQL Server, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Transfer data from multiple similar Redshift tables to a single SQL Server table

Login to Redshift and SQL Server -> Select source Redshift tables -> Set the target SQL Server table -> Copy Redshift data to SQL Server

Choose source Redshift database and logon.

convert Redshift data to SQL Server data - Choose Redshift and logon

Choose target SQL Server database and logon.

convert Redshift data to SQL Server data - Choose SQL Server and logon

Click “Convert Similar Tables” at task dialog.

Import data from multiple similar Redshift tables to 1 SQL Server table - Task Window

then show the wizard.

1. Select similar Redshift tables.

Convert data from multiple similar Redshift tables to 1 SQL Server table - open query results

2. Select a destination SQL Server table and config fields.

Combine multiple similar Redshift tables data to a single SQL Server table - select table

3. Preview data.

Migrage data from multiple similar Redshift tables to 1 SQL Server table - preview

4. Import data from multiple similar Redshift tables to a single SQL Server table.

Merge multiple similar Redshift tables to a single SQL Server table - import

More about Redshift to SQL Server converter

See also: