Scenario : The application consumes data from multiple databases.
Application code references database tables using a combination of the server, database and table name.
How to migrate the application instance to azure ?
SQL Server Stretch Database.
Access your SQL Server data seamlessly regardless of whether its on-prem or stretched to the cloud. You set the policy that determines where data is stored and SQL Server handles the data movement in the background. The entire table is always online and queryable. And, Stretch Database does not require any changes to existing queries or applications
The location of the data is completely transparent to the application.
SQL Managed Instance.
The managed instance deployment model is designed for customers looking to migrate a large number of apps from on-prem or Iaas , self-built or ISV provided environment to fully managed PaaS cloud environment, with as low migration effort as possible. Using the fully automated Data Migration Service ( DMS ) in Azure, customers can lift and shift their on-prem SQL server to a managed instance that offers compatibility with SQL server on-prem and complete isolation of customer instances with native VNET support.
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
No comments:
Post a Comment