Jump to Navigation

Database

DB2 - platform and version migration/conversion

Fri, 10/26/2007 - 07:45 — mark

Recently we had upgraade a db2 8.1 database running on Windows to db2 9 running on a Linux based server. From the IBM documentation it appeared that it was possible to upgrade the database and change platforms but it was quiet difficult to find out exactly how.

Open Source: 
Database
db2

Why identity/auto incrementing column implementations can be a pain

Mon, 08/27/2007 - 08:45 — mark

Auto-incrementing or identity columns are often used as surrogate keys in database designs. Unfortunately there is no apparent standard for this feature so each database vendor handles the requirement in a slightly different ways. I find this confusing when moving between database vendors and a lot of time is wasted finding out how the feature is implemented in a particular database implementation.

Open Source: 
Database

Basic understanding of DB2's architecture and concepts

Thu, 08/23/2007 - 21:29 — mark

The last two project I have been working on both used IBM's Db2. Most of my database experience in the past, has been with MySQL, Postgres and Microsoft MSSQL and the architecture that IBM's database takes was somewhat different to what I am used to.

Open Source: 
Database
db2

How to import and export csv files with Postgresql

Fri, 06/22/2007 - 13:47 — mark

Importing and exporting data and csv files from a database are two fundamental tasks that developers and database administrators need to performed on a regular basis. The PGAdmin tool that is used to graphically administer postgresql databases does not have this functionality build in. Postgresql, however does make provision for this. There are two ways to copy csv files to and from postgresql databases. You can use the SQL "copy" statement or you can use the psql "\copy" command.

Open Source: 
Database
postgres

Importing Pastel customer info into vTiger

Sun, 05/06/2007 - 22:54 — mark

We recently had to import some masterfile information from Pastel into vTiger for a client. Since a lot of SA companies use Pastel I thought I would write "how to" to help others to use vTiger and get a state of the art, open source, CRM system up and running.

This "how to" assumes a clean vTiger database i.e. a fresh vTiger install. It would not be hard to get the scripts to workwith a database that already has data. The scripts would need to be adjusted for the next crmentity sequence number.

Open Source: 
Database
MySQL
vTiger

Database Support - MySQL, Postgres Open Office Base

Databases are the mainstay of any business critical system today. They enable the central storage and retrieval of transactional information for many business processes and allow for the advanced reporting of management information. Key to any business system then is the database platform used and the database design for your applications.

Open Source: 
Database
MySQL
postgres

Simple mysql backup script.

Sun, 04/22/2007 - 23:21 — mark

Here is a simple backup script that we use to backup MySQL servers where there are a large number of databases. Each database is dumped out to separate file making restoration for individual databases much easier. Usually scripts dump all databases out into one large file. This is problematic if there are many databases and some of them are large. Simple copy the script into /etc/cron.daily to have it executed each day.

Open Source: 
Database
bash
MySQL

Database Support - MySQL, Postgres Open Office Base

Databases are the mainstay of any business critical system today. They enable the central storage and retrieval of transactional information for many business processes and allow for the advanced reporting of management information. Key to any business system then is the database platform used and the database design for your applications.

Open Source: 
Database
Subscribe to RSS - Database


by Dr. Radut.