How to transfer data from production to development, but scramble sensitive data?

Setting today

We currently have two SQL databases:

  • Production database
  • Database Development

We keep the table structures updated using the Entity Framework Code First Migrations, which is great because it is in version control.

Task: how to process data.

We never transferred production data from production to development, simply because we have a lot of confidential data that we don’t want (or even allowable because of less security) in our development database.

It includes:

  • Personal user data
  • Emails for customers and users

- PROD TEST , , .

:

. , "" ?

-, :

  • (, , / )

, .

Azure Database,.NET/Visual Studio Entity Framework ORM.

+4
1

Fortune 50 . , , , , . - ... , , .

, , , , . , , .

, , .

( ) , "" .

+1

All Articles