Transferring an SCCM MS SQL server to another server

Evgen Kotov 1 Reputation point
2021-10-22T05:22:30.137+00:00

Hello,

The need for migrating MS SQL Enterpise servers intended for SCCM on MS SQL Standard
Please tell me how to perform steps to transfer the bases?

Is it possible to migrate the database on MS SQL Standard on another server, and then in DNS change the IP address MS SQL Enterprise on MS SQL Stnadard?
It turns out as follows in the SCCM, the SQL server name will remain old and when accessing it it will already refer to the new one.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2021-10-22T08:01:05.197+00:00

    Hi @Evgen Kotov ,

    Did you want to create an alias for SQL server instance, then you can move the databases from server A to server B, but the application do not affect due to that change? if I misunderstood, please let me know.

    You can using old alias name to create an alias for new instance, delete the old alias for old server, then the application can connect to the new instance using old connection string.

    refer to this MS document Create or delete a server alias for use by a client.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments