Sql server to Azure migration

Question

We are planning to move our DB from on premise SQL server 2012 to Azure. What are the issues we can face in this task? Please provide any link for forum or documentation which can be helpful in this.

Do we need any software installation for this other then SSMS?

Answer 1

See

http://itproguru.com/expert/2015/03/how-to-move-or-migrate-sql-server-workload-to-azure-sql-database-cloud-services-or-azure-vm-all-version-of-sql-server-step-by-step/

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 2

hello Visakh,

You can use Microsoft's Azure Database Migration (Azure DMS) for migrating your on-prem SQL Server database to Azure SQL Database.

Some useful links below.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

https://azure.microsoft.com/en-us/services/database-migration/?&WT.srch=1&WT.mc_id=AID631184_SEM_kZm90uWB&lnkd=Bing_Azure_Brand&msclkid=7fe9b82e568612adc09ae2485ee3ddba

Please let us know if you have any questions or run into any issues.  You can submit your questions at our UserVoice below.

https://feedback.azure.com/forums/906100-azure-database-migration-service

Thanks

Raj Pochiraju

Program Manager,

Data Migration team

Microsoft