Migrate on prem MS Access DB Tables into AWS RedShift

0

Hello, what is the recommended way of doing this and can someone point/provide me step by steps from scratch please?

Would it be better to import from this on Prem MS Access DB into on Prem SQL Server first and then afterwards up into AWS RedShift or something else?

(Believe will need some type of AWS RedShift ODBC driver to be installed on the prem Windows Server machine?)

Also to consider if the Tables that are being exported from original source MS Access into final target AWS RedShift contain Keys(Primary, Foreign), Constraints, Indexes, Triggers, etc...

Thanks in advance.

posta 2 mesi fa60 visualizzazioni
2 Risposte
0
profile picture
ESPERTO
con risposta 2 mesi fa
profile picture
ESPERTO
verificato 2 mesi fa
0

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.

AWS
con risposta 2 mesi fa
profile picture
ESPERTO
verificato 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande