PHP Classes

Database conversion: Convert database specific SQL to neutral SQL code

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,305 All time: 2,959 This week: 488Up
Version License Categories
dbconv 1.0The PHP LicenseDatabases, Text processing
Description 

Author

Ben Yacoub Hatem

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
Innovation award
Innovation award
Nominee: 4x

  Files folder image Files (2)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloaddbconv-2005-01-16.zip 2KB
Downloaddbconv-2005-01-16.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,305
This week:0
All time:2,959
This week:488Up
User Comments (1)
Excellent
15 years ago (kishore kumar)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.