Database Web Publishing

Softsilver Transformer converts your data into XML without any programming. It enables you to convert text files, Excel workbooks, Access databases or any other ODBC compliant data sources (SQL Server, MySQL etc.) into XML. Text files can be in fixed width column or delimited formats and you can extract data from spreadsheets or databases by either selecting a worksheet/table or running a SQL query and filter by columns and rows. The XML layout can be previewed and easily designed, using drag and drop. In addition, you can also automate your transformations using a command line utility (included). Softsilver Transformer provides an easy-to-use step, by step interface and detailed documentation.

ASPRunner Professional enables you to create a set of ASP pages to access and modify data from a database, including Oracle, SQL Server, MS Access, DB2, MySQL, FileMaker or any other ODBC datasource. The generated ASP pages can optionally allow the user to search, edit, delete and add data into database. In addition, it can restrict access to the data with a login page either with a specified username/password or existing user information from the database. The program comes with an easy to use step-by-step wizard that allows you to publish your database without any programming. You can specify which fields to include, which fields to be searchable and more. It can save the files to your IIS virtual directory, in which case there are no further steps required by you. ASPRunner allows you to publish an existing database in a matter of minutes. Advanced users can further customize the code to change the design - this is not provided by the software.

WebMerge generates static HTML pages from your exported database. It works with any database that can export to .txt format or spreadsheet, including Microsoft Access, FileMaker Pro, Panorama, AppleWorks, and Excel. You can use your favorite HTML editor to design custom templates for your index and details pages and then let the program generate the content based on them. WebMerge uses a simple tag replacement procedure where it replace a custom tag with a field content from your database. The program also lets you save its settings to a file that can start generating pages by just opening it, completely automating your workflow. Since the resulting pages are simple HTML format (based on your template), you can upload them to any server without the need for database access. All database processes are done on your local machine when the files are created. Disadvantage of this program is that you have to export to txt file first and cannot

DBForms from MS Access to PHP + MySQL enables you to convert Microsoft Access databases (.mdb) to AJAX based web pages, using PHP and MySQL to query and display the data. The program does not require any coding on your end, all you have to do is select the database, choose the tables to be include and customize the output. The data can be directly transferred to a mySQL server or saved as SQL dump file. Other features include Unicode support, command-line mode and automated conversions via scheduler. Supports all MySQL server and MS Access data types.

Data ASAP enables you to generate ASP or PHP pages that allow web site (or Intranet) users to to connect to your Access, SQL or MySQL database. A step-by-step wizard assists you in selecting the database and query/output options, and customizing the output design - no scripting is needed, as all the pages will be generate for you. Data ASAP can generate search forms/results, detail pages, administration pages to add/delete data, login pages and more. It enables you to create a completely web based management and presentation of your database. Additional features include data driven DropDown Lists, Custom Template support, Relational Capability to other tables, Secure Login, Image support, Ranges, and built-in FTP client to upload the pages to your site.

access2asp is a conversion tool for access databases. It allows you to automatically convert a Microsoft Access database to clean, commented ASP or .NET code. It also produces a front end and an admin section with ability to add, edit and delete records. All SQL statements, DSNless connection, javascript validation for required fields, forms in admin, as well as all asp code are automatically generated in one click. The created pages are very basic in design and mainly intended to be a foundation for further development.

DBForms from MS Access to PHP + MySQL enables you to convert Microsoft Access forms to interactive PHP based web pages that interact with a mySQL server. The program provides a step-by-step wizard to select the data to be published, and can automatically upload the generated script pages to your web server. The data conversion worked fine, and the program properly converted the forms in our test database, however the design of the HTML pages is very basic, and lacks proper navigation and options to customize the output design. It does the job, but the results are very crude.