Azure sql db migration procedure

  • vsamantha35


    Points: 11039

    Hi All, 

    HI have some questions related to Azure SQL Migrations. 
    How different a sql azure db migration is different from of on-prem sql server migration ? what are the steps involved in order to migrate an on-prem db to sql azure db? Also, what kind of objects do we migrate when we are doing sql azure db migration ? because when we do on-prem sql migration we take backups of system dbs, app dbs, certifications, logins, sql agent jobs , xps, linkedservers etc... So, similaryly do we to do all these for sql azure db migration for somethings can be ignored like creation of jobs, linked servers .. so on and so forth?

    Can anyone please elaborate on this ?

    Thanks ,

  • Grant Fritchey

    SSC Guru

    Points: 395510

    Oh yeah, this is very different. The traditional approach will not work with Azure, at all.

    Now, the question I would have is, are we talking about migrating between Azure environments or are you talking about moving a database from a traditional SQL Server instance to Azure SQL Database? If we're talking the former, it's just a question of scripting the security and then migrating that to the new location. The database itself can be moved through a bacpac process, although you should only do that from a copy of the database in order to avoid issues with active transactions.

    If we're talking moving from an instance to Azure SQL Database, then you have a bunch of work in front of you. Most importantly, there are no cross database queries, so any of those in your code have to go. There are also a few things unsupported in Azure SQL Database (CLR for example, there are others), so make sure you're not using those. Again, no backup & restore, so you have to look to bacpac. SQL logins or Azure Active Directory are supported. If you don't have AAD configured (and hooked into your local AD), you'll have to do that first.

    This is a big topic. I'd suggest looking to the Microsoft documentation on the topic. There's a lot of it.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • vsamantha35


    Points: 11039

    Thank you Sir. Will definitely go and check the documentation.

Viewing 3 posts - 1 through 3 (of 3 total)

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