Get to the cloud faster with Azure SQLDB Managed Instance and Database Migration Service

Play Get to the cloud faster with Azure SQLDB Managed Instance and Database Migration Service
Sign in to queue

Description

A new, expanded Azure SQL Database offers fully-managed server instance with greater compatibility with SQL Server application features and more, and the ability to move hundreds of databases at once using the Database Migration Service. It provides security isolation with Azure Virtual Network, along with built-in HADR, built-in intelligent performance tuning, and intelligent security services that are already available in Azure SQL Database. To reduce the friction of transitioning your relational database estate to public cloud, expanded Azure SQL Database provides SQL Server application compatibility including commonly used cross database references using three-part names, CLR, SQL Agent, Transactional Replication, Change Data Capture, Service Broker, and a lot more. We showcase a five-step seamless migration experience from your on-premises SQL Server instances to expanded Azure SQL Database using the newly announced Azure Database Migration Service.

Day:

0

Session Type:

Pre-Recorded

Code:

P4008

Embed

Download

The Discussion

  • User profile image
    Lalit

    What if the sql db has some clr based stored proc, will that get migrated?

  • User profile image
    Susanthab

    Great feature! 

    Of course you demoed the migration for very tiny dbs. Has any testing been done for very large databases or what is the maximum size of the database the testing is done? What will be the impact to the primary database while the data is being migrated? 

  • User profile image
    vit100

    What is that? Migration from local network? Do you mean that local network and servers inside exposed to public IP? 

    Do you realize it is not real situation? May be for Hello world it is good demo, but in reallity no way -).

    You'd better to show how to push data from your local DB to Azure - how you do this via SQL server manager.

     

Add Your 2 Cents