Getting to know the DB of SharePoint 2007

When I was searching on SharePoint 2007 database analyzers initially I got so many other products including links to main SharePoint Migration Tools available. Those tools do provide analyzing to a certain extent but it can be costly due to licensing issues.
So my friend suggested to refine my search! I did! And the results were marvelous :)
The results I got were a basic tool Microsoft provides free of charge which, amazingly, gives a whole load of information on the DB.

The tool, which is SPDiag v1.0, is included in the Microsoft SharePoint Administration Toolkit v3.0, available for download at the following locations:

• Microsoft SharePoint Administration Toolkit v3.0 x86: http://go.microsoft.com/fwlink/?LinkId=141504
• Microsoft SharePoint Administration Toolkit v3.0 x64: http://go.microsoft.com/fwlink/?LinkId=142035

Documentation for SPDiag is available from those download pages as well.

When Initiating a SharePoint Migration

When we initiate a SharePoint 2007 to 2010 migration, it is vital to first understand the current system and its functions. Otherwise migration targets are not achieved.
In order to check the current system we need to access the customer's system internally. This is a thing we need to keep at it's minimum because customers are not always willing to expose their business system for long periods of times.
Therefore we need to use some quality analytical software which can crawl around the full system and generate a full report about the corresponding system. It is better to use software which can do this with the minimum exposure and minimum time possible to keep customers happy.
There are some freely available tools available that does the analyzing part pretty well.

• SharePoint Analyzer
• Xavor SharePoint Admin Tool
• Microsoft SharePoint Administration Toolkit

 And there is a commercially available toolkit also.

• Admin Report Kit for SharePoint 2007 (ARKSP) 

Refer my other blog here.