14,494 questions
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
You may use tsql and run the task in agent job if you have set up linked servers.
Best regards,
Percy Tang
How can we move active company ids from source server to target server database table in sql server at every sunday?
![](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(201.6, 86%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NN
0
Reputation points
How can we move active company ids from source server to target server database table in sql server at every sunday?
SQL Server Other
{count} votes
-
Olaf Helper 47,436 Reputation points2023-09-06T06:29:37.9466667+00:00 That's really to less on informations, please provide much!! more details about the situation and the requirements.
Sign in to comment