We have a legacy ASP Classic application (intranet/internal access only) that has a simple web form that finds and displays SQL Server data. It also allows users to upload documents (stored on the webserver with a SQL Server record to the location)
Due to this application’s simplicity, and because Sharepoint already has all the domain security and document upload functionality, I was wondering if this application could be rebuilt using Sharepoint rather than rewrite the web app in a newer version of ASP.
The current application works like this:
ASP Classic page with a form and 3 search fields. Form submits to itself and calls a SPROC to find matching records passing in the 3 search fields as SPROC params.
Resulting search results are displayed in an HTML table.
Clicking a search result then reloads the page calling 3 or 4 more SPROCs that get the related data of the single selected search item. This data is then displayed in 3 or 4 more HTML tables.
Users can also add a list of custom external Web or Shared Drive URLS, and upload documents which are stored on the web server file system with a SQL record link containing meta data.
I’m a SQL developer/DBA with some minor web dev experience but never touched Sharepoint so I’m wondering if this is an appropriate use case for Sharepoint or whether I’m better off simply rebuilding in ASP.NET Core Razor.
First step here is understanding if I’m selecting the right tool for the task before getting into the detail.