- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Warehouse 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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks for your reply. Do i have to do this for each single table or is there a function for all tables?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Fabric Monthly Update - February 2025
Check out the February 2025 Fabric update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-20-2025 03:58 AM | |||
10-28-2024 09:07 AM | |||
08-06-2024 07:09 PM | |||
09-25-2024 06:10 AM | |||
02-01-2025 09:23 AM |
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
3 | |
2 | |
2 | |
2 |