Attaching DB error while performing Attach-DB Upgrade from SP 2007 to 2010

While performing the database-attach upgrading method I came across many errors yesterday. Some were silly errors like typing errors ;) . But there were some serious errors too like the one I describes in my previous post yesterday.
The last error I logged in to my previous blog post was an error in SQL authentication while trying to run the DB attach command in powershell.
The command was like this,

PS C:\Users\sgunasena> Mount-SPContentDatabase -Name WSS_Content_4455 -DatabaseServer local -WebApplication http://cd-sgunasena:7788

And I tried several ways changing commands and changing databases. But it did not work out. It seems like I was having an issue with SQL authentication. Since this is a work environment I'm not provided with unlimited access to machines, yet I am in the machine admin group. And also in SQL server settings I have given the user all the rights necessary. I'm still looking into the authentication issue.
So the Powershell command didNOT work out for me.
So I consulted a friend of mine and discussed about this. Friend came up with a different command using the command prompt or the old fashioned way!
And of course it worked out fine.
You have to first move into the 14hive in order to perform it using the following command.

C:\Program Files>cd C:\Program Files\Common Files\Microsoft Shared\Web Server Ex
tensions\14\BIN

And then you need to execute the following command in order to get it done the correct way.

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsa
dm -o addcontentdb -url http://cd-sgunasena:7788 -databasename WSS_Content_4455

 

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.