0
Azure SQL SqlServer

Migrate sql server database to azure

Backup Process-Using context menu(or right click on the database we need to restore )

2.

 

 

3 Give name (extension is .bacpac)

4.

5. Execution in progress

6. Export as Data-tier Application success

7. Check the location

 

8. Now connect to azure sql db (Restore the database )

9.

10. Now get connected to Azure SQL DB

11. Using Context menu

12. Choose Import Data-Tier Application

13. Choose the file you have taken as backup

14. Choose the Azure SQL Database settings (Based on the subscriptions ) you will get different set of offerings

15. Choose and click next

16. Summary windows

17. In progress

18.  Its successfully restored on Azure Server

19. Validate -> Here we have restored on azure

Hope this will help you : Please put your feedback/suggestion

 

 

You Might Also Like...

No Comments

    Leave a Reply