Migrating SQL Database On-Premise to Azure SQL Database using database replication

In this video, I will provide the complete details of database migration from on-premise to Azure SQL Database using database replication.

#azuresql #sql

[ShwetaSharma-rggm]

One of the best series very well explained please bring sql data warehouse topic as well.

[thavanamsravani]

what is recommended use case for Azure SQL
(a)-Migrate all instances of Microsoft SQL server to Azure SQL to improve security and reduce Cost.
(B)Migrate your on–permises SQL server instances directly to azure and get all benifits of migrated instances.
Which is correct option ?

[kishoreevani]

Hi Sir.. thank you so much for this video sharing. I have tried it and identified 2 issues during setup I would like to share them here.
1. from on-premise to Azure dbo schema is not allowed.

I have tried with new schema created and fixed this issue.

2. Got TSL error post replication setup. PFB error message
Number: 47072
Message: Reason: Login failed due to the client TLS version being less than the minimal TLS version allowed by the server.
I have fixed this by changing the TLS in firewall settings - Minimum TLS version from 1.3 to 1.2

Finally set up the replication by following the same steps in your video.

If possible please do videos on Managed Instances (MI). Thanks in advance.

[lakshithayaan]

What are the network settings between Onprem and Azure Sql for replication to work

[sreekanthbusa]

Well explained by Azure SQL Mastery.

For which scenarios we have to choose these tools(DMA, Data Replication, SSMS?

[MuhammadWaqas-grgg]

I have a request brother...now a days a method used by majority of companies is Azure Data Studio...Please if you could make a SQL migration video using Azure Data Studio...i would be grtful...

[SumantKumar-fntd]

so, there is no need of distributor database ? i think in replication it is required as well.