This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 57.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
I need to copy multiple tables from one server to another server where I need to truncate the tables daily and load it again.
But all my tables are having foreign key references where I cannot use truncate .
Could anyone please help me here
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hello @Priyanka Vemula ,
Just checking in to see if the below answer provided by @Nandan Hegde helped. If it answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hey,
you can start the truncate queries from the child table and then start populating from parent table.
meaning use a script activity with sequential execution of truncate tables from child to parent
and then use copy activity to sequentially load the tables from Parent to child