581BP Web Solutions.http://www.aspcompanion.comWe specialize in providing web design and consulting services. Our goal is to deliver all the best the Internet can bring to your business, as a high quality, customized and affordable solution, tailored to your needs.ASP > Scripts and Components > Database ToolsOct 10, 2006
There are plenty of tools out there to document your SQL Server, but none offer an easy to use web interface to document your database's columns. The best part is that you are writing directly into SQL Server's description field, if you back up your database, you also back up your documentation!
myLittleDataGrid allows you to easily and quickly create dynamic tables of data containing information list. With myLittleDataGrid you can easily include links, images, and set automatic pagination for long lists.
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.
myLittleBackup for SQL Server 2000 and 2005 is the the first Backup/Restore solution specially designed for Shared SQL Server Hosting. With myLittleBackup, shared SQL Server hosting companies will be able to give their customers an easy and secure solution to backup/restore their databases.
Is that feasible to dynamically create DSN and check data via internet from any computer? This small application, named as SQLmap, is valuable for those who is responsible for building or maintaining a web site and SQL Server database. This apllication helps to access all servers and then access all databases stored in each server. Then with the interface provided you can view tables, records in each table through browser from any computer, You can even write SQL query to retrieve data from table that meet the criteria specified.
I have developed many intranet and internet projects using ASP and SQL Server. After projects are delivered, it is highly possible that customers suggest further revisions for the deliverred project as they get more experience with the project. Any revision should be tested by accessing remote database. In most cases, we need to immediately know table data on remote SQL Server for successful test. For example, I finished shopping cart project with SQL 6.5 database and ASP in Dallas then ftp the whole project and database to Whasington D.C. Later, I was asked to modify some pages related to database. As I need real data to test ASP pages, in this situation, we can ftp SQLmap (list on table below) to Server in D.C. So we can view table data on remote SQL Server through internet.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.