Migration Strategies
As it stands, our solution addresses all the requirements identified in the problem analysis. It also provides a SQL Server database as a scalable backbone to build further enhancements, such as client programs that can query real-time sales data. However, the system also has a few potential headaches as a result of its evolution from Excel and Access. This final section addresses some of these problems and considers how the application might be enhanced in the future.
Adding Security
Currently, the ASP.NET page allows fairly open access to the database. Any individual who submits an Excel file that matches the prescribed format can commit order information. A better approach is to implement some sort of authorization that restricts ...
Get Microsoft® .NET Distributed Applications: Integrating XML Web Services and .NET Remoting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
