Forrester Research: Open Source Databases Are Cheaper

November 22, 2006 at 16:50 · Tags: , , , , , , , , ,

Open source databases can save enterprises up to 60 per cent over proprietary products, according to data collected by Forrester Research.

Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.

Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.

Open source databases ‘60 per cent cheaper’ @ Vnunet.com

Related posts:

  1. Nasdaq moves to open-source
  2. InfraRecorder: Open Source CD Burning for Windows XP/Vista
  3. Skype Open Source
  4. Ubuntu Howto: Install Oracle
  5. Sun acquires MySQL
  6. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  7. an ex-microsoft employee’s view on Linux and the open source community
  8. Windows Open Source Software
  9. Open Source EPJ
  10. Major List of Useful Open Source and Freeware Software

Comments

MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL

September 22, 2006 at 14:01 · Tags: , , , , , , , ,

Today I was working on how to convert an old Microsoft Access database into a MySQL database. This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin.

To export a given table from a mdb-file, we type:

mdb-export db.mdb customers >> customers.csv

In my case, since I got some danish characters, I need to force mdbtools to encode everything as ISO8859-1 instead of UTF-8, which is the default. This can be done by setting the environment variable MDB_ICONV to ISO8859-1

export MDB_ICONV="ISO8859-1"

The resulting CSV-files coult be imported into MySQL using phpMyAdmin.

MySQL Logo

Another howto on database migration ms2pg – Migrate Microsoft SQL Server Database to PostgreSQL Database.

Related posts:

  1. Sun acquires MySQL
  2. Optimize MySQL for Low Memory Use
  3. Recover (Crack) a password from a Microsoft Access Database (mdb)
  4. MySQL Performance Monitoring and Optimization Tools
  5. NO to the Microsoft Office format as an ISO standard
  6. Forrester Research: Open Source Databases Are Cheaper
  7. MySQL Optimization and Performance Tips
  8. Howto: How to Reset the MySQL Root Password
  9. Executing SQL Statements from a Text File
  10. Slow Query Log Analyzes Tools

Comments (6)