设计和开发一个站点，该站点将显示所有受支持的数据库，与其连接的应用程序及其所有者 [英] Designing and developing a site that will show all databases supported, applications connecting to it and their owners

问题描述

我以SQL DBA的身份工作，而我的老板只是给我一个任务，以开发一个站点，该站点将能够显示我们支持的所有数据库，其所属的客户端以及连接到表中每个数据库的应用程序和图表形式...我从哪里开始以及如何解决此任务迷失了.

非常感谢您的帮助
在此先感谢您

I work as a SQL DBA and my boss just gave me the task to develop a site that will be able to show all the databases that we support, the client it belongs to, and the applications connecting to each database in a table and diagram form... I''m lost as to where to begin and how to tackle this task.

Your help will be highly appreciated
Thank you in advance

推荐答案

1.您应该创建实用程序数据库以进行跟踪.
或者，如果您足够熟练，则可以从系统视图中提取大多数数据.

2. 以表格形式显示数据非常简单，但是我建议您在以下方面走一步一次学习asp.net基础知识.在大多数书籍或教程中，显示​​和处理数据通常是第二课/第二章，因此无需着急.

3.在您的网站上有很多显示图表的选项，我喜欢这一个. br/> 一些替代方法是Crystal报表，.rdlc报表，免费的第三方控件等.

最终，技术的选择取决于您和您的资源(Visual Studio版本，有针对性的.Net框架，时间，技能，老板的耐心:) ...).

祝你好运！

1. You should create utility database to keep track.
Or if you are skilled enough you can extract most of those data from system views.

2. Showing data in table form is pretty straightforward, but I advise you to go one step at a time and learn asp.net basics. Displaying and manipulating data is usually second lesson/chapter in most books or tutorials, so no need to hurry.

3. There are many options for displaying diagrams in your web site, I like this one.
Some alternatives are Crystal reports, .rdlc reports, free third party controls etc.

In the end choice of technology is up to you and your resources (Visual studio version, targeted .Net framework, time, skills, boss''s patience :) ...).

Good luck!

这篇关于设计和开发一个站点，该站点将显示所有受支持的数据库，与其连接的应用程序及其所有者的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！