Forum Discussion
smpa01
Community Champion
Community ChampionCopy Job best practice
I have to copy n tables from a on-prem SQL DB to a lakehouse with a copy job
do I create n different copy jobs (similar to create n differnt dataflows)
or
can I create a single copy job to acco...
suparnababu8
Super User
Super UserHi smpa01
No need to create n different copy jobs to copy n number of tables from your on-premises to Lakehouse. Just one copy activity is enough. Recently I publshed a blog on this in Fabirc blogs sesction.
Please go throuh this blog - Seamless Data Migration from On-Prem SQL Server to... - Microsoft Fabric Community
Hope this helps you.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!