Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

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.