Azure SQL Database: How to Migrate Encrypted Data

You need to migrate to Azure SQL Database, and you have encrypted column data that you need to protect! How do you migrate it? Daniel Taylor, aka @DBABulldog , has got you covered! Let's step through multiple ways that we can get that data migrated.

Chapters
00:00 Intros
00:53 The story and examining if a Table has column level encryption (CLE) enabled
01:34 The SQL Migration Extension / DMS error
02:28 First alternative to Migrate the DB with CLE enabled - Import Database bacpac
03:38 Second alternative to Migrate the DB with CLE enabled - bcp
03:57 Prep Azure SQL DB for bcp
05:47 Run the bcp
06:09 Examine out data and ensure that are keys are setup correctly using ADS and SSMS
07:41 The Import has completed let's look at the outcome

Scaling Heights: Migrating a 400GB Database to Azure SQL!

Provision Always Encrypted keys using SQL Server Management Studio

Export and import databases using Always Encrypted

Bulk load encrypted data to columns using Always Encrypted

FAQ about using Azure Database Migration Service

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field

Bradley Ball

Daniel Taylor

Neeraj Jhaveri

Josh Luedeman

Andrés Padilla

Bradley Schacht

Marco Aurelio Cardoso

#AzureSQL #Encrypted #Encryption #Data #DataEncryption #DataMigration #migration

[kudakwashemujiri]

Thank you for the above Sir, very informative and helps. I kinda have the same scenario with encrypted SPs, would you know how anything about how to do this.