Trying to import On Prem sql server into azure managed instance but it's failing

TymeMachine 0 Reputation points

Trying to import On Prem Sql server into azure managed instance but it's failing.What should I do?

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. darin wolfe 0 Reputation points

    Hello, @TymeMachine

    If your attempt to import an on-premises SQL Server database into an Azure Managed Instance is failing, follow these steps to troubleshoot and resolve the issue:

    Check Compatibility:

    Ensure that your on-premises SQL Server version is compatible with Azure SQL Managed Instance. Some older versions may have compatibility issues.

    Network Configuration:

    Verify that your network configuration allows connectivity between your on-premises environment and Azure. Ensure that any firewalls or network security groups are configured to allow traffic.

    Size and Resources:

    Confirm that the Azure Managed Instance has enough resources to handle the size of your database. Check storage limits and available compute resources.

    Backup and Restore:

    Use the backup and restore method to move the database. Create a backup of your on-premises database and store it in an Azure Blob Storage. Then, restore the backup to your Azure Managed Instance.

    Azure Data Migration Service (DMS):

    Consider using Azure Data Migration Service, which provides a guided, reliable way to migrate your databases. It can handle schema and data migration with minimal downtime.

    Check Error Messages:

    Review any error messages carefully. They often provide specific details about what went wrong. Common issues include insufficient permissions, unsupported features, or connectivity problems.

    Update Drivers and Tools:

    Ensure that you are using the latest versions of any tools or drivers involved in the migration process. Outdated tools can cause compatibility issues.

    Consult Azure Documentation:

    Refer to Azure documentation for detailed guidance on migrating SQL Server databases to Managed Instances. It includes best practices and step-by-step instructions.

    Support and Community:

    If you continue to face issues, consider reaching out to Azure support or checking online forums and communities for additional help and shared experiences from other users.

    By following these steps, you can identify and resolve common issues that may arise during the migration process.

    I hope it will be help you


    darin wolfe

    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more