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?
DatabasesDB2PostgreSQL
Last Comment
Gary Patterson, CISSP
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.