SQL DB migration

• ShuaibV

  SSCrazy

  Points: 2001

  More actions

  June 7, 2024 at 5:31 pm

  #4426944

  Hi

  I am New To Azure Sql.  Can some one please share

  •  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure SQL database?
  • how to restore db from one azure sql database to another azure awl database?

  Thanks

• Perry Whittle

  SSC Guru

  Points: 234011

  More actions

  June 7, 2024 at 11:06 pm

  #4427032

  Have you read the MS documentation firstly?

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Phil Parkin

  SSC Guru

  Points: 246867

  More actions

  June 8, 2024 at 9:39 am

  #4427092

  ShuaibV wrote:

  Hi

  I am New To Azure Sql.  Can some one please share

  •  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure SQL database?
  • how to restore db from one azure sql database to another azure awl database?

  Thanks

  For the purposes of encryption? Yes, you can.

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• Perry Whittle

  SSC Guru

  Points: 234011

  More actions

  June 8, 2024 at 10:24 am

  #4427096

  I thoroughly recommend you read all the documentation but see below

  ShuaibV wrote:

  Hi

  I am New To Azure Sql.  Can some one please share

  •  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure SQL database?

  you’ll want to run some sort of migration compatibility to ensure azure SQLDB is a suitable target

  ShuaibV wrote:

  • how to restore db from one azure sql database to another azure awl database?

  Thanks

  Depends if tde is using a customer manager key or platform managed key

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Perry Whittle

  SSC Guru

  Points: 234011

  More actions

  June 9, 2024 at 10:55 pm

  #4427300

  ShuaibV wrote:

  • how to restore db from one azure sql database to another azure awl database?

  Thanks

  double checked this and it’s not supported with sql db, managed instance supports restoring the dbs to same or another instance but it depends on whether a customer managed key or system managed key is used

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉

• VastSQL

  SSC-Dedicated

  Points: 36081

  More actions

  July 9, 2024 at 5:27 am

  #4434410

  ShuaibV wrote:

  Hi

  • how to restore db from one azure sql database to another azure awl database?

  You can restore Azure SQL DB to same instance with a different name. If you are planning to rename the existing db make sure to start with your secondary replica first.