SharePoint 2010 + load data from old database

%3CLINGO-SUB%20id%3D%22lingo-sub-2232471%22%20slang%3D%22en-US%22%3ESharePoint%202010%20%2B%20load%20data%20from%20old%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232471%22%20slang%3D%22en-US%22%3E%3CP%3EHey%3C%2FP%3E%3CP%3EAfter%20moving%20from%20SHP%202010%20to%20SHP%202019%2C%20I%20need%20to%20review%20the%20audit%20log%20data%20from%20one%20of%20the%20old%20content%20databases.%26nbsp%3B%3CBR%20%2F%3ESince%20I%20did%20a%20content%20migration%20using%20ShareGate%2C%20and%20not%20the%20good%20old%20attach%20database%20approach%2C%20the%20old%20audit%20log%20data%20is%20only%20present%20in%20the%20old%20databases.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20question%20is%2C%20how%20can%20one%20access%20that%20old%20database%3F%20Is%20there%20some%20kind%20of%20tool%20that%20can%20look%20into%20the%20database%3F%20I%20am%20trying%20to%20avoid%20having%20to%20do%20the%20whole%20database%20attach%20thing%2C%20since%20I%20am%20thinking%20that%20would%20require%20that%20I%20first%20upgrade%20that%20old%20database%20to%20SHP%202013%20and%20SHP%202016%20before%20I%20can%20actually%20attach%20in%20SHP%202019.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20this%26nbsp%3Bchallenge%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-ML%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232471%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hey

After moving from SHP 2010 to SHP 2019, I need to review the audit log data from one of the old content databases. 
Since I did a content migration using ShareGate, and not the good old attach database approach, the old audit log data is only present in the old databases. 

So the question is, how can one access that old database? Is there some kind of tool that can look into the database? I am trying to avoid having to do the whole database attach thing, since I am thinking that would require that I first upgrade that old database to SHP 2013 and SHP 2016 before I can actually attach in SHP 2019.

 

Any ideas on this challenge?

 

-ML

1 Reply
You'll need to attach the database to _a_ SQL Server, it doesn't have to be a production SQL server, but that will be step #1. From there, you can browse the dbo.AuditData table in the Content Database using SSMS or Azure Data Studio.

You will need the SiteId and the UserId will be associated with data from the dbo.UserInfo table.

While I cannot find the AuditData table schema document (may not exist), you can find the bitwise flags, enumerations, etc. for the table at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo/18a44781-ea93-43e1-a292-b26....

The UserInfo table schema is at https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-wssfo3/6c3a31c9-475c-42ef-b5e4-68....