Migrate Access Applications to Power Platform Today in GCC!
HTML-код
- Опубликовано: 5 июл 2024
- Learn how you can automatically migrate data from Access applications into Power Platform's Dataverse. In this interview, we discuss with Judd Gravelle how this feature works and how it is supported in our US Government sovereign clouds as well.
Details on the Power Platform and Access integration announcement can be found below,
powerapps.microsoft.com/en-us...
Check out our other US Federal demos on GitHub below,
github.com/microsoft/Federal-...
Intro: (0:00)
Demo Local Access Database: (1:24)
Demo Dataverse Migration: (3:41)
Canvas App Integration: (11:20)
Wrap up: (13:10) 
Наука
Thank you for the video, Steve! This is really helpful.
You're very welcome!
Thanks very much, this is exactly I need in this moment...
Glad it was helpful!
Steve, thanks for bringing in Judd to demo this for us. Just a couple of clicks to migrate legacy Access databases is a great feature. I work with an organization that will be able to make use of this as they migrate their data to the Power Platform.
Glad you enjoyed it!
@@SteveWinward pls let us known what version of ms access have dataverse. Pls tell us
@@akokohjoel9854 365 Version
I needed this
شكرا لكم على مشاركة الأفكار الجديدة
Thank you for sharing that,
My pleasure!
Thank you so much for this video. Question, once I add data in the app it doesn't go directly into MS Access, I need to close access and reopen it to see the new information. Is there a way around this?
How the relation between the table and grandparent tables are imported (query farther than 1 table away)? Since this is a limitation of Dataverse.
So with this linking process; does it matter where the access database is stored after migration? If it is stored on a local computer and that computer is shut down what happens?
This is great! But, can I create only mobile apps? Or, can I use as a mini system on manage my work for example?
Does this work on split databases so when you make and distribute a front end there are basically no tables on the client machines
what abou the reports ? Once I have the data synchronized with the Dataverse and from PowerApps I can make an aplication, is it possible to "migrate" the Access reposts? In my case I have about 180 reports in access. How could you migrate the reports?
This question may have already been asked, but how do I use multiple tables in one application?
What version of ms access support dataverse?
Can I use multiple SharePoint lists (one for each Access table) instead of Dataverse?
You can use SharePoint lists and SharePoint folders as connectors if you want.
Hi Steve, the info in this video is great. I do not get the Dataverse option when I right-click on the table I want to export to dataverse. How do I enable that option?
Exactly, I keep on hearing how easy it is, but there is no link for Dataverse in MS Access to export. It appears you need to setup several items before this "Easy" click export to dataverse.
@@slayer_slash7369 Ditto
@@thomasjones9394 I just setup a free Azure DB/SQL and exported one major 1.7GB MS Access table to it and then removed it from access. I then created a link to the azure table within Access and it works nicely :) .. Now my database is only 688KB :). The only thing I need to do some research on is to fix the slow export of the original 1.7GB table to Azure, which was over 24 hours :x .
@@slayer_slash7369 LOL. Sounds fantastic. How can we talk?
@@slayer_slash7369 I am interested, how did you do, I am finding it difficult.
Dataverse is not being displayed as an export data option in my access data base. what to do?
Take a look at our docs below on this. It looks like you need to first join the Access beta program to be able to do this.
docs.microsoft.com/en-us/powerapps/maker/data-platform/migrate-access-to-dataverse
Where can I find my Environment URL?
Hi Steve (and Judd!). Excellent video! But is there any advantage to migrate Access data to Dataverse instead of Sharepoint?
Great question. Sorry for the delayed response. Dataverse will give you a lot more features and capabilities both on the security options and rapidly building applications with Power Apps. Hope this helps.
It is important to note that Dataverse is not compatible with MS Access. This is due to the fact that the primary keys utilized by Dataverse are not compatible with MS Access. Additionally, it is not any faster than Sharepoint, and it is impossible to use ANSI 92 SQL on your Sharepoint lists.
Dataverse functions more like a Database where SharePoint is more of a file storage.
If users have substantial data on their current Access platform they will perhaps suffer some sticker shock at the monthly cost of Dataverse storage. Let's hope they do some capacity planning before jumping into this data migration.
Every customers use case will be different here. It’s a good point to be aware of costs for Dataverse storage as part of planning. I do think for most customers there are significant benefits to storing their data in the cloud versus hosting their database locally.
@@SteveWinward currently in the process of transitioning various analytics and metrics from legacy NMCI (Navy) and intranet to Power Apps Dataverse, SharePoint Online, and One Drive for business.
The 2gig limit for access does it applied to dataverse?
Dataverse has much higher limits than access databases.
@@SteveWinward Hi. So are we able to append (from Access) to the dataverse table? 2gig limit was always a problem, so if I understand correctly, the dataverse overcomes this issue. ie You can keep running your old macros/VBA in Access to clean data but now append to the final LARGE Dataverse table that has much higher limits than 2gig.
@@jamiegrayson3739 Based on my experience, Dataverse trashes everything you have done in access. I tested it with several automated macros that do inserts and updates and it will work for a while and then it will stop working. AzureSql is a better option for ms access developers or a CentOs server with Postgresql
Dataverse, where I it in ms access ? I don't have that export options. What's going on?
Same with me
I have never heard of GCC, what is that?