PHP Classes

Database conversion: Convert database specific SQL to neutral SQL code

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-01-16 (11 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,293 All time: 2,830 This week: 971Up
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: 37
All time rank: 211 in Tunisia Tunisia
Week rank: 361 Down1 in Tunisia Tunisia Equal
Innovation award
Innovation award
Nominee: 4x

  Files folder image Files  
File Role Description
Plain text file DBConv.php Class Main class
Accessible without login Plain text file sample-oraconv.php Example sample usage to convert an oracle DB

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,293All time:2,830
 This week:0This week:971Up
 User Comments (1)  
6 years ago (kishore kumar)