- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa