Forum Discussion
Helper IVWarehouse data from prod to test
Hi,
does anyone have an idea how to get the data from warehouse from prod to test workspace? I need something like onprem "backup from prod database and restore on test server".
Transferring the metadata (objects...) works with Source control, but for testing purposes in need the table data also.
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.
4 Replies
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.
