What are the steps to migrate an on-prem SQL db to Azure SQL?

  • Almost 4 years ago I blogged about migrating a on-premise SQL database to Azure SQL. I'm sure that in the intervening time, that process has changed. So, what are the steps today (August 2018) to migrate, or at least duplicate an on-premise SQL Server database to Azure SQL?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • I've got a post here on SSC, which looks like it addresses my question. Following this I'm starting to run the Extract Data-tier Application. I've specified a different location to store the DAC package, but the Extract Data-tier Application wizard complains with an error that says, "Invalid file name". The file name is a valid Windows filename, so I don't understand what the problem is.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Rod at work - Friday, August 17, 2018 9:24 AM

    I've got a post here on SSC, which looks like it addresses my question. Following this I'm starting to run the Extract Data-tier Application. I've specified a different location to store the DAC package, but the Extract Data-tier Application wizard complains with an error that says, "Invalid file name". The file name is a valid Windows filename, so I don't understand what the problem is.

    Have a look at, the still in preview, Managed instances, a game changer!
    😎

  • Thank you Eirikur, that looks interesting and that it will address our needs.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply