Transfer MS Access Database Directly To PostgreSQL In 4 Simple Steps

PostgreSQL, casually known as Postgres, is a cross-platform, open source object relational database management system (ORDBMS) which supports a hosts of operating systems, including, Solaris, Linux, Windows, Mac OS X, and FreeBSD. Postgres includes support for all SQL constructs, ranging from subselects, user-defined types, transactions, etc., while containing a variety of native data types such as, Boolean, XML based Xpath queries, Geometric Primitives, Composite and so on. Users who frequently port MS Access database formats,  ACCDB, ACCD, MDB, and ACCDE to PostgreSQL database generally relies on different complex methods which often include exporting and importing database tables manually. If you want a relatively easier way to send selected MS Access database tables to PostgreSQL server or create a compatible SQL dump file for PostgreSQL database, check out MS Access To PostgreSQL.

MS Access To PostgreSQL is a wizard-based Access database porting utility which supports all Access database formats, including, MDB, ACCD, ACCDB, etc. The password-protected databases tables can also be sent directly PostgreSQL server without having to unlock the database. It includes two convenient options to export Access database to PostgreSQL database, including SQL dump and direct transfer. The direct transfer requires specifying Server connection details, including Server path, Port, Maintenance DB, username and password, whereas, SQL Dump needs only target location to be specified.

To get started, launch the application and specify the Access database source path. If database is encrypted, you will need to enter security settings, including username and password.

Read more: Addictive tips
QR:

Posted via email from Jasper-net