Informix 7.30 (I know!)



We have a need to migrate the database from a running Production server on to a Pre Production machine which will eventually replace the Production Machine. This is a Transaction Processing system so we want the migration to happen without any downtime.

We plan to take level "0" back from the Old box , restore to the new box and then apply the delta using scripts( Unload /load) to bring the data in sync.

Is there a way by which after we have taken a level "0" backup , we can then take another backup of whatever changed after level "0" and apply that to database using some informix utility.I am not sure if a Level "1" will do the job as while the Level "1" is being restored we will have a down time.

NSV


.



Relevant Pages

  • Re: Trouble moving db to another sql2005
    ... from one SQLServer (right-click on the database in the Management ... error that the on disk structure was 611 and the production machine ...
    (microsoft.public.sqlserver)
  • Re: Informix 7.30 (I know!)
    ... >We have a need to migrate the database from a running Production server on ... >to a Pre Production machine which will eventually replace the Production ... Wasn't "no downtime", but the total downtime was very ...
    (comp.databases.informix)
  • Migrating from ? to Oracle
    ... I'm going to be working on a Perl app using a database through the DBD ... The end production machine will run Oracle for which ... we don't have access to Oracle locally and wish to use a ... functions of the various DBI drivers that would be great. ...
    (perl.dbi.users)
  • Re: Change datatype on all table (HELP, HELP, rush)
    ... You will want to test this before running it on a production machine to make ... sure that you do not loose any data... ... > I need a way to change a datatype from nvarchar to varchar on all tables ... > within a database. ...
    (microsoft.public.sqlserver.programming)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)