Login   Register  
PHP Classes
elePHPant
Icontem

Database conversion: Convert database specific SQL to neutral SQL code

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (9 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,282 All time: 2,762 This week: 1,419Up
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: 36
All time rank: 211 in Tunisia Tunisia
Week rank: 224 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,282All time:2,762
 This week:0This week:1,419Up
 User Comments (1)  
 
Excellent
4 years ago (kishore kumar)
70%StarStarStarStar