1

Topic: Export of all tables to files/migrations on other DBMS

Good afternoon.
Prompt as it is possible to carry out export of all or some tables cache ` in text files? Wanted to migrate them on other DBMS. Or can as that directly it is possible?

2

Re: Export of all tables to files/migrations on other DBMS

vitabios;
To migrate it is necessary to understand, and what the receiving party how you can load this data understands?
To Cache it is possible it will be connected on ODBC/JDBC and so at desire with to migrate

3

Re: Export of all tables to files/migrations on other DBMS

4

Re: Export of all tables to files/migrations on other DBMS

DAiMor
DirksDR
Thanks for answers. Unfortunately I with it practically did not work, therefore I ask to excuse for primitive questions in advance.
The receiver can be mysql / posgres / db2 (last more preferably, but it is not basic.). I can connect this DB through connection sql the gateway cache. But me the variant with CACHE through ODBC would be more preferable to incorporate easier) and to "download" the tables necessary to me in the DB. Here in any way I will not find a software which could be made it.
How to learn classes from me or ?

5

Re: Export of all tables to files/migrations on other DBMS

vitabios wrote:

how to learn classes from me or ?

For this purpose it is necessary to know, what you know about those "tables"?:-D
P.S.
All one  in . wink

6

Re: Export of all tables to files/migrations on other DBMS

vitabios wrote:

how to learn classes from me or ?

If you will adjust ODBC-shnyj DSN to Porridge, and you will not see through it the table - application means uses immediately .:(
If application uses SQL at data access to Porridge, means there should be tables.
Or application too "a black box"?

7

Re: Export of all tables to files/migrations on other DBMS

DirksDR wrote:

Or application too "a black box"?

Here always torment the same application... smile)) Truth I already forgot its title.

8

Re: Export of all tables to files/migrations on other DBMS

And I even more often note;
That as though someone changed me)
(COS)

9

Re: Export of all tables to files/migrations on other DBMS

DirksDR, through ODBC connection all tables I see. Here I think as them .