Zbigniew Baniewski <zb-pij/[EMAIL PROTECTED]> wrote:
found this interesting feature - but I'm not quite sure, how it's working, and manual doesn't contain a good example.
All ATTACH DATABASE command is giving you is the ability to run statements across database files. There is no magic replication going on, or anything like that.
1. Copy the entire contents of existing database from file into :memory:. Can I "just copy database" (both structure & data) in one shot - or I've got to recreate a "twin database" structure in :memory: first, and only then copy data from the "main" database?
You will have to recreate the schema and copy data over, one table at a time.
3. When finishing: save changed :memory: contents into "main database" file. Will it be automatically saved when DETACH-ing :memory: ? I'm afraid, no?
No. You will have to do the same replication process as in #1, only in the other direction.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
