RE: Duplicating a Database
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BD1F4D.D69E3FC0 Content-Type: text/plain Check out Enterprise Replication (formerly called CDR). You could get replication going for the two DB's, then just stop it when you're ready for the 2nd DB to go off on its own. ER is available with OnLine 7.22 or greater. NOTE: Don't confuse this with the older and much more restrictive HDR product. ============================= Paul Mosser, Open Systems DBA Wells Fargo Bank Tempe, Arizona, USA mosserp@wellsfargo.com > ---------- > From: Bill Weaver[SMTP:billw@fscorp.com] > Reply To: Bill Weaver > Sent: Monday, January 12, 1998 7:23 AM > To: informix-list@rmy.emory.edu > Subject: Duplicating a Database > > We are in the process of splitting off a portion of our business which > will > continue to be processed utilizing our Informix system. As a result, > we are > creating a second database for this business which will run under the > same > instance of Informix. My question is, what is the easiest way to keep > these two > databases in sync while development and testing is going on and then > allowing > them to be two separate databases once this new business starts going > on line. > It's important for the 2 databases to be identical until the cutover > date at > which time they can and will start diverging. Is there an easy way to > do this? > -------------------------------------------------------- > Name: Bill Weaver > E-mail: Bill Weaver <billw@fscorp.com> > Date: 01/12/98 > Time: 09:23:59 > > This message was sent by Z-Mail Pro - from NetManage > NetManage - delivers Standards Based IntraNet Solutions > -------------------------------------------------------- > ------ =_NextPart_000_01BD1F4D.D69E3FC0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IgETAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAbAAAAUkU6IER1cGxpY2F0aW5nIGEgRGF0YWJhc2UAGwkB CYABACEAAAA0QkQwRTJGNDVGOEJEMTExQUI1RjAwMDA4Mzc2MTJCQQAjBwEggAMADgAAAM4HAQAM AAsAIAA7AAEASQEBBYADAA4AAADOBwEADAALACgABwABAB0BAQ2ABAACAAAAAgACAAEDkAYAyAgA AB0AAAADAC4AAAAAAEAAOQAARTXjkR+9AR4AcAABAAAAFwAAAER1cGxpY2F0aW5nIGEgRGF0YWJh c2UAAAIBcQABAAAAGwAAAAG9H36CEJGoypaLXxHRn5UAAPhIzlgABJ/sgQACAQkQAQAAAHwFAAB4 BQAA3gkAAExaRnVJ142YAwAKAHJjcGcxMjX+MgD/AgYCpAPkBesCgwBQEwNUAgBjaArAc2V0fjIG AAbDAoMOUARVAgBwcHJxMSAIVQeyAoMzdwPGBxMCgzQDxRRFEL9mhjUW+hLic3RlbQKAbn0KgAjP Cdk7Gz8OMDUvAoAKgQ5xC2BuDhAwM4UVsGgFsHpkb2MAANoqElUgApEfQGwfdQr7WxOxC/JjAEAU oGgFkGv2IAhgBUBFAjAEkBRgBAAaZQfwZQtQDeBhdGkpAiAgKAIQcgeAcmxkeSAjwGxsCYAUoETA UikuICBZCGAkwNUIYGwlIGcSwCAbQCOYJGdvC4BnICRBIHQDIjAn4HdvIERCJ0xzLCfiA6BqdRoA IKEaAG9wIGkFQHco4pp5CGAnG0AmgWFkJLD5J7YybiUgKHAn4ChQJ1A/InAOkCJwA6ApwAQgb3cy biWBRVIpsAQgYXY/C3ALYAJgI1AD8CfwIE+MbkwLgCNQNy4yEuBvBbEJwSPQBJAuCoUKhU6wT1RF OihgAiAnBUDZBaBuZikwKBFoLaEuc58n8gbwBIEtwCuhbXUScF8zwAWwKpIaAAUQYyPgdnUjUEgl UCAUYARwM+B0hzAmCvsW4jE3ID03r7M4aTX1UGEmEAXQbwQQ8wSQKLBPcCjxGeQEIChwskE19Vdl JPAEIEYKwNUsMUIAcGs19VQaIDrAKyiwBxF6AiBhKLBVU0c7pgRgOlJwQHc8Mmb1PJIuBaBtNf8h TECbI6AIMTgwAtFpLTE0/jQOsAzQQ/MLWUNwQLADYPMaEDTQIC1GF0CXRMsMMP1FlkYDYTFQRK9F tAyCPNAfAxADIDwgLdAEkFtTTZBUUDpiSuF3QATh9QWwcEBSXUa/R80jciSw/FRvSP9KD0sVTP9H zQZgnwIwT39QizowK6BheSiwekoAcHUKwCSwDiAosDGIOTk4LyA6MjMWMH5NUg9HzU9fUG0LgCRC aSx4LSOgGgBAJGB5Lj8aIAWwXSE1oFgvUx51Ys5qRdFaT1CLRHUjlSeB7mEoYCPQAaBhErAwPEL2 /DM2RJcVsiGzRJFFpTwg3y3AKoELgCfjNXFjB5As8X0sgHMjkQJAJ3IsYmLgcM8a4SPyaCEIYSBi KTAu8f8EESnwDeAuoAPwSvFAlTHR92KRClAr8mJnhyURIpADEPc+IGizahFJXDUpYBnzJYHuQS2x NGImEHQosD+wZuP/a4YvwmKkErAx0SUgVlBjJM8npS2hak9K8XJ1A6B0wPMzUifyc2EHgDCWC4Aa AF8AcGfQaBJuZiWBTSSwcf8KUBoAI/IEAHAxEoAFQC2hfyfyKsAAkDSBKeBWYCvya/8J4CmgJ/Ey IihBQJVyVgQg/2cxbvB2oGrCLkEOcDUAGtD+cAeAAjAzgxoQeCEngS2h/ydUJAF+EyjiJOEtECdy QJX9J/FtbHUoMhKwQMEv4XvJ/wIgdrEyUy8AB+Bzd3ZxACCffukjoC8AJYFAlUl0KJD/KbA9sBrh AHAFQCsXe8lshH5pDnBsESTRdOFtkSfjY/0ikG9LUXJCZtEFQECVatT/I+B1sSfxJLJ/dGszhLNy QO808TygJ3ElgUl5IyqBA5HfeYEksHoFHvAyQz9AlUYY/5HPkt+TqjCmdaExUFFfIrBOLQDAAxCV ayA8S+4+R0CVYwGVUTAxLw4gLy9XgD0mB3GZsTlXwTo1+jkwPFQyYgeBdZAmUHnxi4SRfdJiJLBa LU0t8b850ANgRgAnoANhB7F0njD/PlAmUDCmn0aesQ5wI6BLUf8GQXaBVlALIAQgPOBtQm5gfTSg YZ8xBgAG8G2BAiBz/5DPpK+lv5P/ZE8hOUWWQJUFGmEAqtAeADFAAQAAABAAAABNT1NTRVJQNDM5 OTFEQTcAAwAaQAAAAAAeADBAAQAAABAAAABNT1NTRVJQNDM5OTFEQTcAAwAZQAAAAAADADYAAAAA AB4AQhABAAAALAAAADxDaGFtZWxlb24uODg0NjE1MzcwLmJpbGx3QHR1Y2suZnNjb3JwLmNvbT4A AwAmAAAAAAACAfk/AQAAAGcAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VMTFMg RkFSR08gJiBDTy4vT1U9V0ZCMS9DTj1OT04tRVhDSEFOR0UgUkVDSVBJRU5UUy9DTj1NT1NTRVJQ NDM5OTFEQTcAAB4A+D8BAAAADQAAAE1vc3NlciwgUGF1bAAAAAAeADhAAQAAABAAAABNT1NTRVJQ NDM5OTFEQTcAAgH7PwEAAABnAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPVdFTExT IEZBUkdPICYgQ08uL09VPVdGQjEvQ049Tk9OLUVYQ0hBTkdFIFJFQ0lQSUVOVFMvQ049TU9TU0VS UDQzOTkxREE3AAAeAPo/AQAAAA0AAABNb3NzZXIsIFBhdWwAAAAAHgA5QAEAAAAQAAAATU9TU0VS UDQzOTkxREE3AEAABzAgSsABkR+9AUAACDBmevTjkB+9AR4APQABAAAABQAAAFJFOiAAAAAAHgAd DgEAAAAXAAAARHVwbGljYXRpbmcgYSBEYXRhYmFzZQAACwApAAAAAAALACMAAAAAAAMABhD7kwEk AwAHEP4EAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAAQ0hFQ0tPVVRFTlRFUlBSSVNFUkVQ TElDQVRJT04oRk9STUVSTFlDQUxMRURDRFIpWU9VQ09VTERHRVRSRVBMSUNBVElPTkdPSU5HRk9S VEhFVFdPREJTLFRIRU5KVVNUU1RPUAAAAAAepw== ------ =_NextPart_000_01BD1F4D.D69E3FC0--