Ben Hart
asked on
Informix - dbexport/dbimport.. silly question
Say you have DB1.. if you successfull run dbexport on that database. And let's say you lose the exported file(s).. is the data still contained within DB1 and in a current state that you could fire up the instance and access the data like nothing happened?
You should be able to. About 99.9% of the databases don't actually delete the data during the export process, they just make a copy of it in some sort text readable file.
ASKER
I had hoped there'd be more than one reply. Maybe someone whose done it before?
dbexport is nondestructive. It basically generates a bunch of SELECT statements, so you'll want to disable SELECT triggers before you run an export.
- Gary Patterson
- Gary Patterson
ASKER
Thanks so much Gray. Last thing.. once you dbimport into the new db on the new server.. does this new db need to already be as big as the old one or will it dynamically increase?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.