Hi all,

I was wondering if anyone new how to copy a complete database from one IDS9.4 engine to another one on the same system.
Config is OK, and I can see both engines from any of them.

so basically, what I'd like know is some tips to be able to do a select in tableA.DatabaseA@engineA followed by an insert in tableA.DatabaseA@engineB
And i need that for all tables of DatabaseA at EngineA.
Of course, I want to do that with having to download/upload ...

Can anyone help?
Maybe there is there a script somewhere that actually does that?

Cheers,

Fab

You can take a backup and restore the backup on the same server while changing the chunknames.
You will have to make a copy from your $ONCONFIG and add a few lines in your sqlhosts file.
Do not forget to reserve a port number for tcp/ip connections.

BTW it is select * from database:table@server

Thank you Roewle for your reply.
The thing is that we do not want to go through the disk.
We want to be able to copy from SHM to SHM.
I've tried
select * from database:table@server

select * from sgbci:bkhis@ol_central)
and get the follwing error message:

201: A syntax error has occurred.


I just want to add that I can go in dbaccasse > Connection > Connect, and choose ol_central, and I am connected to ol_central. From there, I can select my databas and browse the table.

Thank you again,

F

select * from database@server:table
Thanks