|
Vol: 48(62) No: 2 / June 2003 Import/Export Solutions between Different Databases Types I. Filip Department of Automattion and Industrial Informatics, “Politehnica” University of Timisoara, Faculty of Automation and Computers, Timisoara, Romania, e-mail: ifilip@aut.utt.ro Keywords: database, PHP, SQL, export/import. Abstract The main goal of this paper is to present several import/export methods between databases related to some local or client-server Relational Database Management Systems (RDBMS), which can be accessed through an Open Database Connectivity (ODBC). As study cases there were considered FoxPro as a local RDBMS, and the following Structured Query Language (SQL) servers as a client-server RDBMS: Oracle, MySQL, Microsoft SQL Server and InterBase. The most of the study cases is implemented using PHP (Personal Home Page) scripts that assist the import procedure. It has been taken into consideration the PHP language due its facility to access a large diversity of database types. All the study cases are exemplified on the data import from a FoxPro database file source, but can be also extended to another RDBMS. References [1] http://www.php.net. [2] http://php.dataplus.se/manual/en. [3] http://www.microsoft.com/sql. [4] http://www.mysql.com. [5] http://www.borland.com/interbase. [6] http://www.oracle.com. [7] I. Filip, Tehnologii de programare a aplicatiilor Internet cu baze de date, Editura Orizonturi Universitare, Timisoara, 2003. [8] B. Morgan and J. Perkins, SQL fara profesor, Editura Teora, Bucharest, 1998. |