Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    60

    Unanswered: copy a database between two engines

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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
    rws

  3. #3
    Join Date
    Feb 2003
    Posts
    60

    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

  4. #4
    Join Date
    Feb 2003
    Posts
    60

    found it

    select * from database@server:table
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •