We're evaluating using SharePoint 2010 as our project management tool.
Specifically, the system needs to satisfy the following:
- Discussion groups
- Project management (simple issue tracking, no complex workflows or vcs integrations)
- News feed for the project(s)
- File sharing based on authorization/user-roles
- Custom homepage
- Custom forms using MS SQL Server as a backend and contents of old forms searchable from the user interface.
Now, I think [1-5] is possible using SharePoint (Comments are always welcome :)). I'm not sure about . Is it possible? For instance, can an admin or a user of the SharePoint portal, create a custom form (without any programming) that uses MS SQL Server as a backend and publish it to the portal so that other users can also perform data entry?
If it can be done (be it with or without some programming), can users perform text search on form data using the SharePoint interface?