Filling one DB with entries from multiple others with the same structure

[Svetoslav Sotirov]

Its probably a blue sky request but is there going to be a way to fill a DB with entries from other DBs with the same structure. Say I have:

User 1 - DB1

User 2 - DB2

...

User N - DBN

Combined DB3 with entries from DB1 and DB2 ...DBN.

[Jason Hills]

Request is unclear.

Copy-Paste works to an extent. And copying a DB and then extending it with a copy paste?

Or, export to CSV, make the changes to the CSV, re-import?

Or do you mean backlinks?

[John Hadaway]

Conceptually I'm guessing that sounds like an Oracle 'create table as' using a union query?

So something like (apologies, my syntax may be rusty)
Create table DB3 as
   (select * from DB1)
   union
   (select * from DB2);

The aim being to create table DB3 containing all rows that exist in DB1 or DB2.

I can't comment whether this is feasible for implementing with Confluence databases, but if I've understood your requirement correctly, maybe presenting the syntax as an example that the devs can ponder might help?

I'd love to see more 'Oracle like' relational database functionality (oh okay then, 'SQLServer like' as well if you must, though the thought irks me!) introduced to Confluence databases, but I can imagine how this would become very complex to implement, and would require understanding of relational theory to fully utilise.

Here's to chasing that blue sky! :)