How can I do a SELECT Statement using Two Databases?

[BytePlayer]

I'm using Delphi EX2 and SQLite3 and I have two separate database files that I need to merge via an SQL statement like:

INSERT INTO DatabaseOne.TableOne (FieldNameOne, FieldNameTwo, FieldNameThree)
SELECT FieldNameOne, FieldNameTwo, FieldNameThree
FROM DatabaseTwo.TableOne

I have a feeling that a tzGroupConnection is the way to go but I can't figure out how to use them at all...!

Any help would be greatly appreciated, particularly if you could give me some sample code!

Thanks in advance.

[EgonHugeist]

BytePlayer,

i've no expierienses with that component. So if you find out how post it here..

[marsupilami]

Hello BytePlayer and EgonHugeist,

Maybe this thread helps about TZConnectionGroup and TZGroupedConnection: http://zeos.firmos.at/viewtopic.php?t=2760

Byteplayer, if I understand that thread correctly, these components will not help you. The special case in your first post seems to be the normal use case for a data pump? Maybe some RDBMSs might allow Queries betwen different databases. But imo this is not the usual case. So what RDBMS do you use? (MS SQL, Sybase ASE / ASA, Firebird, SQLite, ...)

Best regards,

Jan

[BytePlayer]

SQLite3 --- Alternatively do you know is there an existing way to dump a DB to an SQL Query and then run that on the new DB?

[marsupilami]

Hello BytePlayer,

a component for creating sql scripts for inserting - that is something on my todo list. What I can give you is a data pump component. This component is in a state, where I can say, it works for me and some of my customers. If you want to, I can publish it here and write some kind of small introduction on how to use it.
Best regards,

Jan

[BytePlayer]

That would be great! I'd really appreciate it.

[marsupilami]

Hello BytePlayer,

please have a look at the attached components. This is the data pump described earlier and an SQL-Dump generator. Both have limitations. Until now I only use them with Zeos 6.6.6 and Delphi. So if you use newer Delphi versions, especially unicode eneabled ones, or Zeos 7 your mileage might vary.

For using the components, just drop the pas files into a new package, compile and install it. Both files contain a register procedure that will register these both components to your component palette in a Tab called IKS.

The textfiles contain a brief description of the components. The folders contain demo projects. I think that especially for the data pump this is necessary because I had to make some ugly design decisions there ;o)

If you have questions, just ask me.

Best regards,

Jan