I am a SQL Server DBA and have a database that I would like to access via a web browser. It will be used internally on the intranet and will simply be calling stored procedures in SQL Server to enter data into the database and return data into a simple web page. I am not a developer although I'm pretty good at SQL and scripting with powershell. I may use SSRS later to report on the data.
我是一个SQL Server DBA，并且有一个我想通过Web浏览器访问的数据库。它将在Intranet内部使用，只需调用SQL Server中的存储过程即可将数据输入数据库并将数据返回到简单的Web页面。我不是开发人员，尽管我非常擅长SQL和使用PowerShell编写脚本。我可以稍后使用SSRS来报告数据。
My question is which is the best tool for a non-developer to rapidly put together a web front end to SQL Server? I was thinking maybe ASP.NET, Ruby, Powershell, PHP, etc. Which is the simplest?
我的问题是哪个是非开发人员快速将Web前端组合到SQL Server的最佳工具？我想的可能是ASP.NET，Ruby，Powershell，PHP等。哪个最简单？
Where should I host the web application? Apache or IIS? I care more about putting something simple together than creating something fancy and flashy. Any suggestions? As you may have gathered I'm after the simplest solution for rapid development, at the cost of something slick and nice looking (there will only be two users, one of them me).
我应该在哪里托管Web应用程序？ Apache还是IIS？我更关心把简单的东西放在一起，而不是创造一些花哨而华丽的东西。有什么建议么？正如你可能已经聚集在一起，我正在寻求快速开发的最简单的解决方案，代价是光滑和美观（只有两个用户，其中一个是我）。
Thanks, Mark.
谢谢，马克。
5 个解决方案
#1
4
If you are experienced with SQL Server, I would recommend ASP.NET.
如果您对SQL Server有经验，我会推荐ASP.NET。
ADO.NET gives you good access to SQL Server, and with SMO, you will also have just about the best access to SQL Server features. You can access SQL Server from other environments, but nothing is quite as integrated or predictable.
ADO.NET为您提供了对SQL Server的良好访问，并且通过SMO，您还可以获得对SQL Server功能的最佳访问权限。您可以从其他环境访问SQL Server，但没有任何内容可以完全集成或可预测。
You can call your stored procs with SqlCommand and process the results the SqlDataReader and you'll be in business.
您可以使用SqlCommand调用存储过程并将结果处理为SqlDataReader，您将开始工作。
#2
2
The most rapid option is to hand out MS Access or SQL Sever Management Studio (there's a free express edition) along with a read only account.
最快的选择是分发MS Access或SQL Sever Management Studio（有一个免费的快递版）和一个只读帐户。
PHP is simple and has a well earned reputation for getting stuff done. PHP is excellent for copying and pasting code, and you can iterate insanely fast in PHP. PHP can lead to hard-to-maintain applications, and it can be difficult to set up a visual debugger.
PHP非常简单，并且在完成任务方面赢得了良好的声誉。 PHP非常适合复制和粘贴代码，您可以在PHP中快速迭代。 PHP可能会导致难以维护的应用程序，并且可能很难设置可视化调试器。
Given that you use SQL Server, ASP.NET is also a good option. This is somewhat harder to setup; you'll need an IIS server, with a configured application. Iterations are a bit slower. ASP.NET is easier to maintain and Visual Studio is the best visual debugger around.
鉴于您使用SQL Server，ASP.NET也是一个不错的选择。这有点难以设置;你需要一个配置了应用程序的IIS服务器。迭代速度有点慢。 ASP.NET更易于维护，Visual Studio是最好的可视化调试器。
#3
2
For Data access you can use OData. Here is a demo where Scott Hanselman creates an OData front end to * database in 30 minutes, with XML and JSON access: Creating an OData API for * including XML and JSON in 30 minutes.
对于数据访问，您可以使用OData。这是一个演示，其中Scott Hanselman在30分钟内为*数据库创建OData前端，具有XML和JSON访问权限：在30分钟内为*创建包括XML和JSON的OData API。
For administrative access, like phpMyAdmin package, there is no well established one. You may give a try to IIS Database Manager.
对于管理访问，如phpMyAdmin包，没有完善的。您可以尝试IIS数据库管理器。
#4
1
How about using the Dynamic data template that comes with Visual Studio. This could be hosted on IIS.
如何使用Visual Studio附带的动态数据模板。这可以在IIS上托管。
本演练演示如何创建使用ASP.NET动态数据的基本Web站点。动态数据使您可以创建数据驱动的Web站点，只需很少编码或不编码。
#5
1
I think PHP is a good solution. It's simple to set up, free and there is plenty of documentation on how to create a database management app. Ruby on Rails is faster to code but a bit more difficult to set up.
我认为PHP是一个很好的解决方案。它设置简单，免费，并且有大量关于如何创建数据库管理应用程序的文档。 Ruby on Rails编写代码更快，但设置起来有点困难。
#1
4
If you are experienced with SQL Server, I would recommend ASP.NET.
如果您对SQL Server有经验，我会推荐ASP.NET。
ADO.NET gives you good access to SQL Server, and with SMO, you will also have just about the best access to SQL Server features. You can access SQL Server from other environments, but nothing is quite as integrated or predictable.
ADO.NET为您提供了对SQL Server的良好访问，并且通过SMO，您还可以获得对SQL Server功能的最佳访问权限。您可以从其他环境访问SQL Server，但没有任何内容可以完全集成或可预测。
You can call your stored procs with SqlCommand and process the results the SqlDataReader and you'll be in business.
您可以使用SqlCommand调用存储过程并将结果处理为SqlDataReader，您将开始工作。
#2
2
The most rapid option is to hand out MS Access or SQL Sever Management Studio (there's a free express edition) along with a read only account.
最快的选择是分发MS Access或SQL Sever Management Studio（有一个免费的快递版）和一个只读帐户。
PHP is simple and has a well earned reputation for getting stuff done. PHP is excellent for copying and pasting code, and you can iterate insanely fast in PHP. PHP can lead to hard-to-maintain applications, and it can be difficult to set up a visual debugger.
PHP非常简单，并且在完成任务方面赢得了良好的声誉。 PHP非常适合复制和粘贴代码，您可以在PHP中快速迭代。 PHP可能会导致难以维护的应用程序，并且可能很难设置可视化调试器。
Given that you use SQL Server, ASP.NET is also a good option. This is somewhat harder to setup; you'll need an IIS server, with a configured application. Iterations are a bit slower. ASP.NET is easier to maintain and Visual Studio is the best visual debugger around.
鉴于您使用SQL Server，ASP.NET也是一个不错的选择。这有点难以设置;你需要一个配置了应用程序的IIS服务器。迭代速度有点慢。 ASP.NET更易于维护，Visual Studio是最好的可视化调试器。
#3
2
For Data access you can use OData. Here is a demo where Scott Hanselman creates an OData front end to * database in 30 minutes, with XML and JSON access: Creating an OData API for * including XML and JSON in 30 minutes.
对于数据访问，您可以使用OData。这是一个演示，其中Scott Hanselman在30分钟内为*数据库创建OData前端，具有XML和JSON访问权限：在30分钟内为*创建包括XML和JSON的OData API。
For administrative access, like phpMyAdmin package, there is no well established one. You may give a try to IIS Database Manager.
对于管理访问，如phpMyAdmin包，没有完善的。您可以尝试IIS数据库管理器。
#4
1
How about using the Dynamic data template that comes with Visual Studio. This could be hosted on IIS.
如何使用Visual Studio附带的动态数据模板。这可以在IIS上托管。
本演练演示如何创建使用ASP.NET动态数据的基本Web站点。动态数据使您可以创建数据驱动的Web站点，只需很少编码或不编码。
#5
1
I think PHP is a good solution. It's simple to set up, free and there is plenty of documentation on how to create a database management app. Ruby on Rails is faster to code but a bit more difficult to set up.
我认为PHP是一个很好的解决方案。它设置简单，免费，并且有大量关于如何创建数据库管理应用程序的文档。 Ruby on Rails编写代码更快，但设置起来有点困难。