How can we move active company ids from source server to target server database table in sql server at every sunday?

NN 0 Reputation points
2023-09-05T12:36:25.0333333+00:00

How can we move active company ids from source server to target server database table in sql server at every sunday?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,034 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 9,691 Reputation points Microsoft Vendor
    2023-09-06T06:10:53.8833333+00:00

    Hi,

    You may use tsql and run the task in agent job if you have set up linked servers.

    https://stackoverflow.com/questions/189422/how-do-i-create-and-query-linked-database-servers-in-sql-server/189431#189431

    Best regards,

    Percy Tang

    0 comments