DBSchema

Home | About Us | Contact Us

Need gauges and meter charts? See FusionCharts Instrumentation Suite

What is DBSchema?

DBSchema is the description of a MS SQL Server database generated using the data definition language provided by the Database. DBSchema defines attributes of the database, such as tables, columns, procedures and properties. DBSchema is the real time documentation of your SQL Database, generated by a set of ASP Pages, which run in Windows IIS. DBSchema makes it easier for the developers to document the current database schema, as they can easily access it by just entering an URL in the browser, without having to use any software.

Advantages of DBSchema

Easy Access: Often members of the project team need to refer to and document the database. So, when an online database schema is available, it becomes quite easy for them to get the schema by just typing an URL in the browser. Now, to get the schema they don't have to use any external tool or software like Enterprise Manager, Microsoft Visual InterDev etc.
Updated Information: The team gets latest schemas even if the database has been changed just a moment ago. No hassles for updating the schemas - it's all automatically done.
Instant Availability in acceptable format: Since, this page is hosted on the Web server, the schema is available instantly to all project participants who need the schema in a format that is accepted to all i.e., HTML.
Seamless flow of information: The diagram feature in MS SQL Server is not quite flexible, in the sense that it cannot be separately saved. And, if the column property is ON and we print it, it becomes unmanageable, as it will be a lot of pages. Thus, we are left with only one alternative, backup the entire database and send it to the person concerned. So, here comes into play the online database schema. The online schemas are available in HTML format and therefore can be easily sent to anybody. You can also give the URL of the page where the schema is hosted. Thus, information can seamlessly flow with leaps and bounds across continents & zones. Also, when the schemas are associated with the diagram feature, the information we get becomes more fluid and precise.
No need for direct access to the Database: If often happens that when you are hosted on a shared server with a MS SQL Server Database, you just get one login for the Database with the database owner rights. Often, you need to give this login details to the developers to modify the project or enhance it. But now with the help of DBSchema, all that you need to give is a URL which when accessed shows the latest Database Structure and Objects.