Quick base data to Microsoft Dataverse migration

(0) Share

Report

Posted on by Sowjanya_G13

We need to migrate quick base data operations to Microsoft dataverse.Is there any approach which can be done?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

ivan_apps 2,187 Moderator on at

Like (1)

Report

Is this the product you're wishing to migrate? https://www.quickbase.com/

I assume it's possible, as long as you can get an export of the data in either and excel format or if it has an API interface that you can connect to. If you can get all data in excel or an API is available - you should be able to do Dataflows to load that data into Dataverse.

Was this reply helpful? Yes No
Sowjanya_G13 9 on at

Like (0)

Report

Yes Quick base only.As you said data migration is possible with API or excel.But the virtual tables structure,schemas,views,ER's everything has to be rebuild right? Or there is another quick way?
As we need to migrate/rebuild approx400

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

What you’ll be able to migrate is the table schema and data. All business logic, code, workflows and other enterprise triggers would have to be recreated. Forms and views as well have to be recreated. Virtual table representations would have to as well, and a custom provider may have to be created. You really would want a consultant to give you a proper analysis of the work that needs to be done to fully be operational on Dataverse so you don’t set yourself up for failure.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @Sowjanya_G13,

What type of data source do you have?

The quickest way is by leveraging Dataflows. It will automatically create the tables/entities and import all data in one step. It also supports transformation with Power Query and supports numerous types of data sources. More info: https://learn.microsoft.com/power-query/dataflows/create-usec

If you have Access database then suggest having a look at the out-of-the-box migration tool which would be the quickest and easiest: https://learn.microsoft.com/power-apps/maker/data-platform/migrate-access-to-dataverse?WT.mc_id=DX-M...

Hope this helps!

Was this reply helpful? Yes No