Database conversion: Convert database specific SQL to neutral SQL code

Recommend this page to a friend!
  Info   View files (2)   Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,303 All time: 2,928 This week: 365
Version License Categories
dbconv 1.0The PHP LicenseDatabases, Text processing
Description Author

This class is meant to process SQL code with syntax that is specific to certain databases and convert it to SQL code that is database neutral.

The goal of the class is to help avoiding the use of SQL code that is not compatible with all the supported databases.

Currently the class supports converting SQL code specific to Oracle, MySQL, Microsoft SQL Server, SQLite and ODBC.

Innovation Award
PHP Programming Innovation award nominee
January 2005
Number 3


Prize: One downloadable copy of Roadsend PHP Compiler
Sometimes it is convenient to write applications that can work with many different SQL based databases.

Some database abstraction packages can help writing applications that can work unchanged with different databases.

However, if you start using SQL code that uses features that are specific of certain databases, it will be harder to make the applications work with other databases later.

This class can help avoiding some SQL portability problems by converting the SQL code that you use into SQL code that does not use certain database specific features known by the class.

Manuel Lemos
Picture of Ben Yacoub Hatem
Name: Ben Yacoub Hatem <contact>
Classes: 18 packages by
Country: Tunisia Tunisia
Age: 42
All time rank: 241 in Tunisia Tunisia
Week rank: 131 1 in Tunisia Tunisia
Innovation award
Innovation award
Nominee: 4x

  Files  
File Role Description
DBConv.php Class Main class
sample-oraconv.php Example sample usage to convert an oracle DB

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,303
This week:0
All time:2,928
This week:365
User Comments (1)
Excellent
10 years ago (kishore kumar)
70%
 

For more information send a message to info at phpclasses dot org.