Forum Discussion
Helper IIAfter Initial Deployment, How Can We Transfer Actual Data from Dev to Prod in Microsoft Fabric
Hi kasun_rumesh,
Not to my knoweldge. THe only known issue I see is related to warehouses and private link.
https://support.fabric.microsoft.com/known-issues/?product=Data%2520Factory&active=true&fixed=true&sort=published&issueId=1796
Super UserHi kasun_rumesh,
Generally, you do not want to move data between DEV and PRD.
In most set ups, DEV is connected to dev/tst systems, and PRD is connected to production systems, this is to avoid bogging down the production enviornment with development, and to comply with company privacy policies and local legsligation where applicable.
If you must use the same data for development and prod, what I would recommend is you load all your data to a "data" workspace that sits outside of dev/prd, and then use shortcuts to reference that data in dev and in prd.
This does carry the risk that something going wrong in dev can impact prod destructively, so be careful and ensure you have strong controls in dev.
kasun_rumeshYes, I agree with what you said. However, I am looking for a solution to transfer data between environments. I have also noticed that Lakehouse schemas are not carried over across environments.
- tayloramy
Hi kasun_rumesh,
There is no automated way to do that in Fabric. You will need to build pipelines or notebooks that move the data across.
- kasun_rumesh
Are there any known issues when using the Copy Job activity to transfer data from a Lakehouse?