Migrating mission critical database from SQL on Prem to Azure SQL

• Mikael Åkerblom

  SSC Journeyman

  Points: 81

  More actions

  March 28, 2025 at 7:42 am

  #4569036

  We are migrating our environments to Azure, it will be a mix of SQL managed instances and Azure SQL instances depending on the different system requirements.

  We offer realtime service to out clients and need to have minimal downtime hen we make the shift. The first database will be migrated to AzureSQL.

  Our on prem database is approx 600GB,

  Our initial thoughts was to:

  1. Do the initial restore (Today we have used Data Migration Assistant)
  2. Pause the Application services - To prevent database access
  3. Do transaction log backup
  4. Upload to Azure Storage Account & redirect the Applications service to connect to the Azure SQL Database & verify connection
  5. Do transaction log restore
  6. Start the Application services - To let the trafic go to the Azure SL database

  Unfortunately we haven't found a way to to transaction log restores from an on premise SQL Server transaction log to Azure SQL.

  Are there anyone that has had experience the same type of challenge and found the best way to to the migration with minimal downtime?

• Eirikur Eiriksson

  SSC Guru

  Points: 182942

  More actions

  March 28, 2025 at 2:50 pm

  #4569278

  Could you please provide more information?

  

  Versions, Recovery Modes etc.