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.
10,918 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 25,301 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.