Unidac structure borrow - MySQL to SQLite

[jonb2]

Hi

I am thinking about buying Unidac.

One very important consideration is being able to create an on-the-fly replication of a MySQL table to an in-memory SQLite table.

IOW, I have my MySQL table in a dataset. I want to be able to create from scratch an SQLite memory table replication of this table without knowing its strcuture and data. This becomes effectively a local cache of the original MySQL table. I have looked at CRBatchmove, but this seems to presume an existing SQLite structure and only moves the data. I want the table creation spec to be driven by the MySQL table I am copying.

Is there an easy answer to do this ?

Kind regards

Jon

[AlexP]

Hello,

Creating new tables on-the-fly in one DB on the basic of the meta-data of another DB is impossible due to the DB types mismatch. Therefore you should create the tables structure before the data transfer by yourself

[jonb2]

Thanks AlexP

Yup, what I thought.

Would be an excellent product. On the fly intelligent mapping between datasets.

Will you have it ready by next week ?

Kind regards

Jon

[AlexP]

Hello,

For correct transfer of structure and data between different DBs, there are particular foreign products produced, and our data accees components don't include such functionality.