Better than ssis there is a different (faster time)approach we can move active data from different databases source server to target server with schedule job.in sql servers.

NN 0 Reputation points
2023-09-01T09:45:41.74+00:00

Better than ssis there is a different (faster time)approach we can move active data from different databases source server to target server with schedule job.in sql servers.

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,036 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 25,941 Reputation points
    2023-09-04T02:43:41.5666667+00:00

    Hi @NN

    What about SQL Server Import and Export Wizard?

    With this, you may schedule job in sql server.

    Or you may describe your issue with more details to see if we could do that via TSQL.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  2. NN 0 Reputation points
    2023-09-05T06:51:06.5466667+00:00

    We want move active company ids from different databases? Source server to target server every month