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?
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.