擅长:python、mysql、java
<p>可以在Python中使用<a href="https://docs.microsoft.com/en-us/azure/sql-database/transparent-data-encryption-azure-sql#manage-transparent-data-encryption-by-using-transact-sql" rel="nofollow noreferrer">Transact-SQLto Manage transparent data encryption</a>:</p>
<pre><code> ALTER DATABASE [databasename] SET ENCRYPTION ON
</code></pre>
<p>下面是示例代码:</p>
<pre><code>import pyodbc
server = '<server>.database.windows.net'
database = '<database>'
username = '<username>'
password = '<password>'
driver= '{ODBC Driver 17 for SQL Server}'
cnxn = pyodbc.connect('DRIVER='+driver+';SERVER='+server+';PORT=1433;DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
cursor.execute('ALTER DATABASE [databasename] SET ENCRYPTION ON')
cnxn .commit()
</code></pre>
<p>希望这有帮助。你知道吗</p>