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 | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 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.