Forum Discussion
Foreign Key columns read-only after export from Access to Dataverse
How do I fix or work around foreign key columns being read-only after exporting my Access database to Dataverse? For context, I'm trying to migrate one of our business apps from MS Access to Datav...
required, but then creates new Relationship columns, e.g. BankAccount.BankLegacyBankId.
Can your share some data specific?
I am not sure what is the problem in detail?
I am not familar with dataverse.
After web search,I guess it may like sharepoint which save datas in ms sql.server.
Re:
For context, I'm trying to migrate one of our business apps from MS Access to Dataverse using the export wizard in Access.
I know some relations are not import to Ms Sqlserver.
So, I just export DDL and insert sql statements and import sql statements in text to other database server i.g. ms sqlserver /mySql.
Can your share some data specific?
I am not sure what is the problem in detail?
I am not familar with dataverse.
After web search,I guess it may like sharepoint which save datas in ms sql.server.
Re:
For context, I'm trying to migrate one of our business apps from MS Access to Dataverse using the export wizard in Access.
I know some relations are not import to Ms Sqlserver.
So, I just export DDL and insert sql statements and import sql statements in text to other database server i.g. ms sqlserver /mySql.