Forum Discussion
Helper IVWarehouse data from prod to test
I would use a lookup/script activity to get the list of table I need to copy and then in a foreach loop pass the name of the table ad "dynamic content" to copy activity source table nome property and table name destination.
HI cw88,
You can create different Lakehouse/data warehouses in different workspaces, then you can use data pipeline/data flow simply copy and move data between these workspaces.
How to copy data using copy activity - Microsoft Fabric | Microsoft Learn
Regards,
Xiaoxin Sheng
cw88Hi Anonymous ,thanks for your reply. Do i have to do this for each single table or is there a function for all tables?
R1k91Super User
I would use a lookup/script activity to get the list of table I need to copy and then in a foreach loop pass the name of the table ad "dynamic content" to copy activity source table nome property and table name destination.
Hi cw88,
In fact, one data flow/data pipeline can handle copy/move data of multiple tables. You not need to do create different processes for each tables.
Regards,
Xiaoxin Sheng