How to tell if Database Certificate Used? I plan to migrate a SQL Server database to another server. There is a certificate listed under the Security > Certificates view in SSMS Object Explorer.

I ran the below query to check if database is encrypted and it is not...

select name, is_encrypted from sys.databases


How can I find if this certificate is used? And how do I ensure successful migration?

Thanks!
This will provide details about the certificates encrypting any database that has TDE encryption enabled:

use master 
select 
    db_name(db.database_id) DatabaseName,
    c.name,
    * 
from sys.databases db
join sys.dm_database_encryption_keys dek
    on
    dek.database_id=db.database_id
join sys.certificates c
    on
    dek.encryptor_thumbprint=c.thumbprint
where
    db.is_encrypted=1


For all other column level encryption within a user database, backup the Database Master Key, migrate it to the other environment and restore it after restoring the user database.