Re: moving a database from one server to another.

If you are coming from a Sun to an Intel box, you had better use dbexport/dbimport or you will have all your bytes swapped. If you use ontape, there are some issues with sizes of spaces, etc. dbimport /export is a bit slower than other methods, it works great for me. Remember the "-l" on dbimport to get logging turned on or you'll need to use ontape to turn it on later. You could run out of log space during the dbimport if you have not resized the logs yet. Just do "onstat -l" in another window and perform ontape -a when they get close to full or if the dbimport freezes; ----- Original Message ----- From: "Strangiato" <spamfreeemail@despammed.com> To: <informix-list@iiug.org> Sent: Monday, August 11, 2003 6:49 AM Subject: moving a database from one server to another. > NT 4.0, IDS 7.3 > > Hi all I'm moving a small database (4gb) from one server to another as > a favour to a mate. > > I'm savvy with IDS on Unix but have never used it on Windows. > > The database doesn't have any blobs. And the source and target > operating systems and Informix versions are identical. The target > machine has much more disk and memory. > > Looking through the manual it looks a little different to Unix. > > May I ask you a few questions? (Pardon my ignorance in advance). > > Should I use onunload/ onload or dbexport/dbimport? > > Do I need to run these commands through a command shell or is there a > nice menu driven system to use? > > Do I need to specify tape block sizes or does the block size default? > > Are there any "undocumented" problems that I should be aware of in > this process? > > Any other comments? > > Thanks in anticipation :) sending to informix-list