Microsoft Azure: Load Data On Azure SQL Database

Sign in to leave a comment.

• 

  Bipin Sethi7y agoPosted Nov 29, 2018, 9:04 AM

  Hi Asma,It is really a nice demo Load Data On Azure SQL server. I have one issues here that how to move all Objects like Stored Procedure, Functions, view etc. as well to Azure SQL server from on premises SQL server as it is easy to migrate all data to Azure SQL server. I did it other way move my on-premises SQL data to Azure SQL Data base as below. Scenario: Connect to my Azure DB with On premises DB and imports all objects like we did in Import/Export way. Appreciate in case you have any idea on the above. Thanks, Bipin Sethi
  • 

    Asma Khalid7y agoPosted Nov 29, 2018, 1:47 PM

    If you want to move local Db completely with data then create. Bkp file and import that on azure SQL server during installation. Another method is to generate auto scripts of your local db then execute that on azure SQL. I hope it helps.
  • 

    Asma Khalid7y agoPosted Nov 29, 2018, 1:49 PM

    Import/export way is usually recommended for small data.. Bkp or scripts way is recommended for large data and Db structure