This project was created with SSMS , a MSSQL server application that scrambles sensitive data in RDBMS according to their datatypes which can later be used for the purpose of testing.
-TECH STACK:
--Transact SQL
--RDBMS Database usage
--Linked server Connections.
--Log table creation.
Description of what Data Scrambler does:
-This project was created with the help of Adventure works database provided by Microsoft and was tested in production database of a company in Chennai.
-The ultimate goal of creating this database based application was to scramble the data columns according to users requests[in this case , a MNC company].
-I have provided an option of customizing the required columns and have provided the company with a log table to log all the details about the number of times this Transact SQL Procedure has been run and it's current status along with it and a description of what has been done to their data.
-Primary usage of this application is that the user can customize how the data should be scrambled - either replace the data with their own option or default data can be used to scramble that column.
-I have also given an option of working with linked servers in case of the server being located in different locations[which is the case in various companies].