Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an existing Windows DB2 database that I'd like to move onto PostgreSQL. The users for the application can live with a weekend's worth of downtime. What's the best way to do that?

share|improve this question

This is how I would do it:

Create a test system with a DB2 and a Postgres server. Try the migration (ideally with some real data from one of your backups). Make sure it works. Create a script that automates the process - and make sure that works, too.

Then, on migration day, set up a redirection to a static HTML page, stop the server, make a backup, run your script. Check that everything went ok.

  • If not, restore the backup.
  • If yes, start the server.

Make sure, that it works, too.

  • Remove the redirection.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.