<div>
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.
</div>


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.

<div>
I had hoped there'd be more than one reply. &nbsp;Maybe someone whose done it before?
</div>


I had hoped there'd be more than one reply.  Maybe someone whose done it before?

<div>
dbexport is nondestructive. &nbsp;It basically generates a bunch of SELECT statements, so you'll want to disable SELECT triggers before you run an export.<br />
<br />
- Gary Patterson
</div>


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

<div>
Thanks so much Gray. &nbsp;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?
</div>


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?

<div>
<div class="content wysiwyg-content">
Say you have DB1.. if you successfull run dbexport on that database. &nbsp;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?
</div>
</div>


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?

Informix - dbexport/dbimport.. silly question

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.