Projects / exportSQL

exportSQL

exportSQL is a script to export all tables in a MS-Access database file to several text files containing SQL instructions: one to delete tables which are about to be created, another to create tables, and one to insert data into the new tables. The resulting table structure and data will resemble the current Access database as much as possible.

Tags

Recent releases

  •  20 Mar 2002 14:47

    Release Notes: This release adds fixes for non-valid characters in field names, boolean values in insert statements, output of created table in a separate file, cr/lf in output files, and invalid index creation with PostgreSQL.

    •  04 Jun 2001 15:30

      Release Notes: Indexes were added to the PostgreSQL dump file format. Comments were improved. Limited support was added for constrains from Access. These constraints are not conveted, but they are dumped to file as comments.

      •  27 Jul 2000 08:50

        Release Notes: A patch has been applied for PostgreSQL support.

        Recent comments

        12 Apr 2001 08:56 dpavlin

        support for Microsoft Access 2000
        Lates changes to this project include additional
        note about modules which are
        required to be checked in Tools/References for
        this module to work.


        If you had problems with this module, add
        Microsoft DAO Object Library and uncheck
        Microsoft ActiveX Data Objects Library.

        Screenshot

        Project Spotlight

        OpenStack4j

        A Fluent OpenStack client API for Java.

        Screenshot

        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.