Migrate on prem MS Access DB Tables into AWS RedShift

Hi

Please follow the link to https://medium.com/sunday-labs/migrate-an-on-premises-microsoft-sql-server-database-to-amazon-redshift-using-aws-dms-b6645a0d8f03

Hello, please allow me to ask a few basic questions first to ensure I guide you in the right way. How much data do you have in the Access database, and what type of workloads do you wish to power with Amazon Redshift? If it is a relatively small amount of data (e.g. <1 TB) and workloads are more OLTP in nature like they are with MS Access, then perhaps Aurora might be the best fit for your use case. If the data is extremely large (e.g. several TBs) or your workloads are analytical in nature, Amazon Redshift is the best fit.

In either case, AWS Database Migration Service (DMS) supports SQL Server migrations and that possibly also translates to support for MS Access databases. If it is a relatively small number of tables that you need to migrate, it might be just as easy to export the MS Access tables to CSV files that can then be loaded into Aurora or Redshift once you have recreated the tables on the target data store yourself. Hope this helps.