Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the best way to Replicate some tables from on premises database to Azure SQL Cloud without using Microsoft DataSync feature?

Windows Azure Web Development Computer Science Microsoft SQL Server
user-image
Question added by mohammed el gebaly , Scrum of Scrums , MIU (Misr International University)
Date Posted: 2016/05/26
Upvote (0) Views (5) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Muhammad Hassan
by Muhammad Hassan , Developer Experience Lead for South Pakistan , Microsoft

You can use SQL Server Mgmt Studio (SSMS) and take a backup and then restore the backup to an already created azure sql DB. You can also look at this MVA course by Microsoft to migrating existing on-prem SQL DBs to Azure SQL, https://mva.microsoft.com/en-US/training-courses/migrating-sql-server-databases-to-azure-16594

Ajin Joseph
by Ajin Joseph , Cloud Operations Engineer Analyst , Accenture Services pvt. Ltd

Backup and restore process (SQL Management Studio ) will be the another best way to replicate table from onpremise to azure

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help