Errors while running Pre-Upgrade Checker

Last week I was doing another test migration using the database - attach method. This time we were trying to simulate a multi-server farm environment.
Before upgrading, as usual :) , I ran the pre-upgrade checker on the SharePoint 2007 test farm we had created. But it returned several unfamiliar errors!

We found out by checking many things regarding permissions the following two were the reasons for causing erroneous reports.

• Additional inactive server in the farm
• insufficient permissions to continue

 This was later resolved by,

• removing the additional inactive server from farm
• re-running the pre-upgrade checker using a more privileged account

These errors occur due to misplacement of simple issues. But these things happen when we are thinking only about the big things and not concentrating on small details. Hope this will help a wanderer :)

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

 

Errors occured while performing Database-Attach Migration

While doing a testing database-attach upgrade from SharePoint 2007 to 2010 I came across some errors.
I was following the steps in Microsoft Technet website and when I was going through database reattaching process I came across several errors and one was like this.

 I found out that I had mixed up the names of the servers I was using. But then there was an error regarding accessing to database.

When I went through some articles in the internet I found out that it was due to the current user not being added to the SPShellAdmin group. This issue can be resolved using this method.

Then again (!) there was another error regarding version incompatibility.

I'm trying get an hotfix for this and rehearse the procedure again.
Today there was a request for a presentation for our head to show to the management, so I had to attend to it with our team :) I will be posting about the updates on these issues!

SharePoint 2007 complete feature list

 When we are researching about SharePoint 2007 to 2010 migration we come across features that are different from each versions, features that does not get upgraded, etc.
 In order to do an effective and complete migration first we need to understand complete feature list of both 2007 and 2010 versions of SharePoint.
 When we were researching my friend "Hasi" found a list of features in SharePoint 2007. This is actually a draft Hasi prepared to discuss with us. I'm posting it as a draft and I will be updating this list as necessary. (And oh forgot to mention that I did ask for permission to post this! Thanks Hasi)

SharePoint 2007 Features

Central Administration

1.       Servers in Farm

2.       Services on Server

3.       Timer Jobs

4.       Incoming/Outgoing E-mail Settings

5.       Web Applications

6.       Solutions

Site Collection /Site

7.       Site Collections                  

8.       Sites

               

·         Collaboration Sites (Team ,Blank, Document Workspace, Wiki, Blog)

·         Meeting Sites (Basic Meeting Workspace, Blank Meeting , Decision Meeting, Social Meeting, Multiple Meeting)

·         Enterprise Sites(Document Center, Records Center, Personalization Site, Site Directory, Search Center)

·         Publishing Sites(News Sites)

9.       MySites 

10.   Web part pages

11.   Basic pages (.aspx pages)

12.   Ghosted/Un-Ghosted Pages     

13.   Recycle bin 

14.   Site collection/site features 

15.   Search Settings, Scopes & Keywords

16.   Site collection usage reports 

17.   Portal site connection 

18.   Audit log reports  for Documents, items, lists, libraries & sites

19.    Site collection policies 

20.    Site hierarchy

21.   Site directory settings 

22.   Regional settings 

23.   User Alerts

Galleries

24.   Master pages 

25.   content types 

26.   Site columns 

27.   Look-up Fields/Lists

28.   Site templates 

29.   Web Parts  (Web Part View Customization)

30.   Web Part connections

31.   Workflows  (Out of the Box, Custom)

32.   workflow History

33.   Libraries (Documents, Forms, Wiki Page, Pictures, Translation Management & Slide)

34.   Lists (Announcements, Contacts, Discussion Board, Links, Calendar, Tasks, Project Tasks, Issue Tracking, Survey, Custom List, Languages & Translators, Import Spreadsheet)         

35.   Versioning (document Library, List)

36.   Folders and Sub Folders

37.   List Items with Attachments

38.   Split or Consolidate SharePoint Lists/Libraries

39.   E-mail Enabled Document Libraries         

40.   Preserve Document/Item IDs 

 Users and Permissions

41.   Site collection/Site administrators 

42.   users , groups  and permissions 

43.   Custom groups and permission levels

Look and Feel

44.   Themes

45.   layout pages

46.   Cascading Style Sheets (CSS)

47.   Navigation , Quick Launch 

48.   site definition 

49.   Views      

Other

50.   Third-party add-ins

51.   Audiences 

52.   Event receivers

53.   Activity Logging                                

54.   Migration (Authorship Columns)                 

55.   Metadata (Custom Metadata)    

56.   Custom Templates

57.   PowerShell Plug-Ins (for using SSMM 2010 with PowerShell)      

58.   Customized JavaScript    

                               

Reference:

http://www.metalogix.net/SSMM/Features/