I need to share a SQL Server 2008 R2 DB with the development team. The data is classified but the schema and the volumes are not. The DB includes all primitive types (long, decimal, nvarchar etc.) but also: XML- some of the XMLs have schemas outside of the DB (application is writing to it). I would expect a masking process to only go on the value and the attribute values, leaving the elements and the attributes as is. Geometry and Geography- the expected behaviour is for the data to maintain the following characteristics: shape and complexity, number of rings (polygon), number of vertices, coordinate system, area. This does not have to be one to one, but if we have a very complex polygon the developers should have something similar in their environment.
How can I scramble the data to declassify it?