Forum Discussion

Frequent Visitor

4 months ago

Solved

best method for migrating a large microsoft access database to data warehouse

I recently have been asked to migrate a large microsoft access database to a fabric data warehouse. From what I have read, exporting the tables into CSVs and then using datatflow gen2 to import the...

data engineering

Srisakthi
3 months ago
Hi mklevemann ,

Yes, As per this documentation you can utilise data flow gen2 to get the data from access db to fabric. Please check the pre-requisites and authentication type it supports.

https://learn.microsoft.com/en-us/fabric/data-factory/connector-access-database-overview

https://learn.microsoft.com/en-us/fabric/data-factory/connector-access-database

Regards,

Srisakthi

Srisakthi

Super User

3 months ago

Hi mklevemann ,

Yes, As per this documentation you can utilise data flow gen2 to get the data from access db to fabric. Please check the pre-requisites and authentication type it supports.

https://learn.microsoft.com/en-us/fabric/data-factory/connector-access-database-overview

https://learn.microsoft.com/en-us/fabric/data-factory/connector-access-database

Regards,

Srisakthi

Forum Discussion

best method for migrating a large microsoft access database to data warehouse

Related content

Migrate fabric warehouse data

Migrate lakehouse and warehouse

Data Warehouse migration to a new account

migration multiple adf jsons template to fdf without microsoft ui migration utitlity

Production-scale ADF → Fabric migration: REST API approach vs Microsoft Migration Utility