Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this guide, you learn how to upgrade your user databases from previous versions of SQL Server to SQL Server 2025 (17.x) by using the SQL Server migration component in SQL Server Management Studio (SSMS).
For other migration guides, see Azure Database Migration.
Prerequisites
Before beginning your migration project, address the associated prerequisites. Learn about the supported versions and considerations for upgrading SQL Server.
To prepare for the migration, use the SQL Server migration component in SSMS.
Premigration
Once you confirm that the source environment is supported and you address any prerequisites, you can start the premigration stage. The process involves conducting an inventory of the databases that you need to migrate. The next step is to assess the SQL Server instances. To assess your source database, use the SQL migration component in SQL Server Management Studio before upgrading your SQL Server instance. After all database assessments are complete, select Save report to export the results to a JSON file for analyzing the data at your own convenience. Next, review the reports for potential migration issues or blockers, and resolve any items that were uncovered.
Migration overview
When you have the necessary prerequisites in place and complete the tasks associated with the premigration stage, you're ready to complete the schema and data migration. A successful migration and upgrade means you addressed all the issues discovered during the premigration stage.
Review the preparation steps for migration of your databases and logins using SQL Server migration component in SQL Server Management Studio.
Preserve backup logs, maintenance plans, and other automated tasks, including jobs, by creating a backup of the system database msdb.
View linked servers by using SSMS. In the Object Explorer, right-click server objects to expand the list.
You might need to consider the following factors, depending on the complexity of your data and environment.
- Troubleshoot orphaned users (SQL Server)
- Migrating Triggers
- Generate and Publish Scripts Wizard
- Mirrored Backup Media Sets (SQL Server)
- Backup overview (SQL Server)
- Editions and supported features of SQL Server 2025
Migrate databases and logins
Next, start migrating the databases and logins using the SQL Server migration component in SQL Server Management Studio.
Post migration
After you successfully complete the Migration stage, go through the post-migration tasks to ensure that everything functions as smoothly and efficiently as possible. The post-migration process is crucial for reconciling any data accuracy issues, verifying completeness, and addressing performance issues with the workload.
For more information about these issues, specific steps to mitigate them, and after the migration see the Post-migration validation and optimization guide.
Verify applications
After the data migrates to the target environment, all the applications that formerly consumed the source need to start consuming the target. You might need to change the applications to accomplish this goal. Test against the databases to verify that the applications work as expected after the migration.