Features
Screen Shots
Download
Product Tour
Turbo Demo
Product Demo
Sample On-Line
On-Line Help
User Forum





dbQwikSite can generate ASP, ASP.net, and PHP script. It can work with many databases such as: MS Access, MySQL, MS SQL, Oracle, DB2, DBase, FoxPro and many more. Not all combinations are available on all platforms. This page explains how you can mix and match in valid combinations.

Design Compatibility Matrix
This table shows what combinations are available for the design stage of creating your web site.

Work Station
Scripting
Database connection
Databases
X-Gen to
Windows
 ASP ADO MS Access, MS SQL Server and all ADO compliant Databases Windows:All
Unix:PHP/MySQL
  ASP ODBC MySQL and all ODBC compliant Databases Windows:All
Unix:PHP/MySQL
  PHP ODBC All ODBC Compliant Databases Windows:All Unix:PHP/MySQL

Publishing Compatibility Matrix
This table shows what scripting language and database technology mixes are supported when you publish to your host.

Server
Scripting
Database connection
Databases
Unix PHP MySQL (native) MySQL
Windows ASP ADO MS Access, MS SQL Server, all other OLEDB compliant databases
  ASP ODBC MS Access, MS SQL Server, All other ODBC Compliant Databases
  PHP ODBC All ODBC Compliant databases
  PHP MySQL (Native) MySQL

Database Compatibility Matrix
This table shows the level of compatibility for database objects that you need between your design database and your target database.

Data Base Object
Target Requirement
Comment
Table Names Identical Name Target database names must match EXACTLY to the design database. Some databases may be case sensitive
Column Names Identical Name Same as above.
Tables All Referenced All tables referenced in the design must be on the target. Tables not used in the design do not need to be on the target. (note that pick lists and other functions may implicitly reference tables)
Columns All Referenced All columns referenced in design must be on the target. Columns not referenced in the design must not be present on the target.
Identifiers Identical All identifiers in referenced tables must be identical.
Data types Compatible Target data types must be compatible with source. For example date fields on the source must be date fiels on the target.
Stored Procedures None Stored procedures are not used by dbQwikSite code and are not required unless for other reasons.
Database Users None Database users can be different.
Indexes Limited Primary indexes (identifiers) must be the same on both source and target. Other indexes can vary, as indexes are not explicitly referenced.
Database Name None Database names can be different. (not the names of objects in your database)
Constraints None SQL statements will be subject to any constraints that you implement in your database.
Triggers None No requirement in dbQwikSite code.
Optionally None Column optionally can differ.

 
Back
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved
145 Room No. 5N6, 5th Fl., Sukhumvit 49 Rd., Bangkok, 10110 Thailand.
Phone: +66 (0)2 762-7802, 762-7803, 762-7804 Fax: +66 (0)2 762-7805
E-mail: Sales@dbQwikSite.com