Link to home
Start Free TrialLog in
Avatar of Richard Lloyd
Richard Lloyd

asked on

Connect PHP to SQL Server with Always on Encryption

Hi

I run web applications with PHP, SQLSRV and MS SQL (2014 web).

With the forthcoming GDRP legislation I am considering encrypting my sql databases. Please can anyone advise if ugrading to SQL Server 2016 (web) and using AlwaysOn Encryption is a possibility. I would like to not have to recode all my queries, but could easily change my connection strings.

I am also looking at row-level security as my database tables are shared across multiple clients, with an an identifiying "clientid" on each record to distiguish which record belongs to which client. Can anyone advise if this is possible and practical.

Thank you
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Lloyd
Richard Lloyd

ASKER

Thanks