What is the easiest way to copy a database from one Informix IDS 11 Server to another

migration rdbms informix administration
pauliephonic picture pauliephonic · Sep 9, 2008 · Viewed 7.9k times · Source

The source database is quite large. The target database doesn't grow automatically. They are on different machines.

I'm coming from a MS SQL Server, MySQL background and IDS11 seems overly complex (I am sure, with good reason).

Answer

Simon picture Simon · Sep 10, 2008

One way to move data from one server to another is to backup the database using the dbexport command.

Then after copying the backup files to the destination server run the dbimport command.

To create a new database you need to create the DBSpace for the new database using the onmonitor tool, at this point you could use the existing files from the other server.

You will then need to create the database on the destination server using the dbaccess tool. The dbaccess tool has a database option that allows you to create a database. When creating the database you specify what DBSpace to use.

The source database may be made up of many chunks which you will also need to copy and attach to the new database.

Related questions

Rails: How can I rename a database column in a Ruby on Rails migration?

I wrongly named a column hased_password instead of hashed_password. How do I update the database schema, using migration to rename this column?

Read More
SQL Server String or binary data would be truncated

I am involved in a data migration project. I am getting the following error when I try to insert data from one table into another table (SQL Server 2005): Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The …

Read More
Rails DB Migration - How To Drop a Table?

I added a table that I thought I was going to need, but now no longer plan on using it. How should I remove that table? I've already run migrations, so the table is in my database. I figure rails …

Read More