Share via

Is there a different approach we can move active data from source server to target server using refresh process that handels copying data without completly wiping out the data for sql servers?

NN 0 Reputation points
2023-08-30T10:21:49.0633333+00:00

Is there a different approach we can move active data from source server to target server using refresh process that handels copying data without completly wiping out the data for 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.
13,823 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,661 Reputation points
    2023-08-31T05:38:49.88+00:00

    Hi @NN,

    You may use SSIS to load data from one server to another.

    In addition, you may also use SQL Server Import and Export Wizard.

    Regards，

    Zoe Hui

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.