Download Executable Attachment
Sometimes we need to upload data to Redshift from SQL Server. But there is no straightforward way to do that. And we have to do the following task manually to import the data to redshift.
Sometimes we need to upload data to Redshift from SQL Server. But there is no straightforward way to do that. And we have to do the following task manually to import the data to redshift.
- Export data from SQL Server to a text file.
- Compressed the file to GZIP.
- Upload the file to S3.
- Execute copy command in redshift.
