Re: Migrating existing SQL application to sharepoint

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Here's my advice for this Sim:

1) Investigate SQL Server Reporting Services for your reporting needs, there
is a web part that integrates in with Service Pack 2 and it should allow you
the control you need over printing and output capabilities.
2) If you've already got an application running as a web app, then host it
on a server and refer to it using a web viewer part. Be sure to design the
app to fit within the minimum size you set the web viewer part to - but you
should be able to run your entire application inside the web viewer, and
integrate it into sharepoint.

Hope this helps,
Lee Drake

"Sim" <sim@xxxxxxxxxx> wrote in message
news:1120655743.289359.240890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have a stand alone Windows application with a SQL backend. It has
> approx. 20 tables associated with it. My question is: what is the best
> way to migrate this application into sharepoint? Do I leave the backend
> relational data as it is and develop web parts for the business
> processes or attempt to port the data over to Sharepoint lists. The
> client would really like the Portal features (alerts etc. as some data
> is in the form of document repositories) to work with the application
> so I would like to try and move the data over.
> Has anyone got any experience with this scenario ?
>


.



Relevant Pages

  • identity impersonate in Sharepoint 2003
    ... Machine and user account runing Sharepoint have been Delegated ... for a stanard aspx page accessing SQL Server Reporting Services Web Service, ...
    (microsoft.public.sharepoint.portalserver.development)
  • RPDataExtraction for SharePoint and SSRS, DEP
    ... program for SharePoint and SQL Server Reporting Services. ... The virtual server that is referenced here is not in the config ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Automatically Printing from SQL Reporting services
    ... Local printing will be in the next service pack. ... MVP SQL Server Reporting Services ... "Ernie" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • RE: identity impersonate in Sharepoint 2003
    ... We already handoff the web service request itself to another assembly. ... We wish to connect to the SQL Server Reporting Services using the logged on ... > is to create a utilities class that includes impersonation. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: .NET Error message
    ... 1.Microsoft SQL Server Reporting services 2005 ... 2.Install Microsoft SQL Server 2005 SP1 ...
    (microsoft.public.sqlserver.setup)