PHP Classes

Database conversion: Convert database specific SQL to neutral SQL code

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,304 All time: 2,959 This week: 204Up
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: 45
All time rank: 241 in Tunisia Tunisia
Week rank: 91 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,304
This week:0
All time:2,959
This week:204Up
User Comments (1)
Excellent
14 years ago (kishore kumar)
70%StarStarStarStar