We have a request from someone who would like an SQL backup of their data to give to an analyst to run Power BI on it.
We will be doing a backup in SQL Server Management Studio, and FTPing a .BAK file.
We don’t want them having access to any of the customizations that we have written and published. So, we need to remove them from the SQL Server database.
Where do I need to go to scrub all of the published data. I know I need to remove any usr field we have added. I already have a script for that. I need the rest of it.
Just looking in the database file, I see:
CustProject which has a structure of:
[CompanyID]
,[ProjID]
,[Name]
,[IsWorking]
,[Description]
,[CertificationStatus]
,[CertificationWarning]
,[CertificationStatusDateTime]
,[DevelopedBy]
,[Hash]
,[CreatedByID]
,[CreatedDateTime]
,[LastModifiedByID]
,[LastModifiedDateTime]
,[ParentID]
,[tstamp]
,[Level]
,[NoteID]
,[SnapshotID]
But that doesn’t contain all of the data.
When I check for any matching NoteID, I also find the file:
SearchIndex
But that doesn't seem to contain the data either. So I think there is another file somewhere, but I can’t seem to find it.
Does anyone know?
