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

1 answer

Sort by: Most helpful
  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.