How can I move a database from OnPremise to Azure using SSMS?



  • I have a large database, about 6Gig in size , its a .bacpac file and I want to copy it to Azure. I am using SSMS and selecting "Import Data-tier Application". It takes a very long time and i get an error "System out of memory exception"

    How can I transfer the database to Azure ?



  • You can do this with https://www.microsoft.com/en-us/download/details.aspx?id=53595 .
    Here's a tutorial: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2