SQL server databases discovery for Azure migrate assessments

Question

Hi Team,
We are planning to migrate the SQL databases to Azure SQL VM using Azure Migrate(lift and shift). Can you please help me to what all configuration need to collect for assessments.

1. SQL server versions.
2. Monitoring tools
3. Backups tools.
4. list of DBs.
5. SQL server license etc.

Thanks

Answer 1

Hi @Sanjeev Reddy,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

When planning to migrate SQL databases to Azure SQL VM using Azure Migrate (lift and shift), it’s important to gather specific configuration details for a thorough assessment.

SQL Server Versions: Identify the versions of SQL Server currently in use. This helps in determining compatibility and any necessary upgrades.

Monitoring Tools: List any monitoring tools currently in use (e.g., SQL Server Management Studio, third-party monitoring solutions). This will help in planning for equivalent monitoring in Azure.

Backup Tools: Document the backup tools and strategies in place (e.g., SQL Server native backups, third-party backup solutions). Ensure you have a plan for backups in Azure.

List of Databases: Compile a comprehensive list of all databases, including their sizes and any special configurations or dependencies.

SQL Server Licenses: Gather information on SQL Server licenses, including the type (e.g., Standard, Enterprise) and any licensing agreements. This is crucial for cost estimation and compliance.

Performance Data: Collect performance data such as CPU usage, memory usage, and I/O statistics. This helps in sizing the Azure VMs appropriately.

Security Configurations: Document security settings, including authentication modes, user roles, and permissions. Ensure these settings are replicated in the Azure environment.

Network Configurations: Note any network configurations, such as firewall rules, VPN settings, and network latency considerations.

Dependencies and Integrations: Identify any dependencies or integrations with other systems or applications. This ensures that all necessary components are migrated and function correctly post-migration.

High Availability and Disaster Recovery (HA/DR): Document current HA/DR configurations and plan for equivalent setups in Azure.

Compliance and Regulatory Requirements: Ensure that any compliance and regulatory requirements are met in the Azure environment.

For more information, please refer the documents: Assessment Overview (migrate to Azure SQL).

https://learn.microsoft.com/en-us/azure/migrate/how-to-create-azure-sql-assessment#azure-sql-assessment-overview

https://learn.microsoft.com/en-us/data-migration/sql-server/virtual-machines/overview?source=recommendations

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.