Results 1 to 3 of 3

Thread: Database Load

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Angry Unanswered: Database Load

    I have dump of two databases of same name e.g. MyDatabase on tape. I want to load these two databases on a new server with two different names like MyDatabase1 & MyDatabase2. Can someone suggest how could I do this?

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    //edit: I seem to have misread your question.
    If I got it right, you have 2 dumps of the same database, and you want those loaded in 2 separate databases.

    You should first create the two databases MyDatabase1 & MyDatabase2 on the new server, with the appropriate size etcetera.
    Then, issue the 'load database'-commands for both databases, using the first dump on tape for MyDatabase1, and the second dump for MyDatabase2.

    If necessary, you can copy the two dumps to separate files on disk (dump1 & dump2) before loading.
    Last edited by Martijnvs; 04-24-06 at 05:48.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Apr 2006
    Posts
    6
    hi,

    you can using service setting on server is :

    -x tcpip(serverport=2368) -n <server name> <database path> // for one database

    -x tcpip(serverport=2369) -n <server name> <database path> // for another database


    and on client odbc with following setting :

    server name : <server name>
    start line : c:\Program Files\Sybase\Adaptive Server Anywhere 6.0\win32\dbsrv6.exe -c 8m -x tcpip

    you can save following entry in asasrv.ini file at client end:

    [server name]
    Link=TCPIP
    Address=199.118.3.2:2638 // for one database

    [server name]
    Link=TCPIP
    Address=199.118.3.2:2639 // for another database


    sunny

Posting Permissions

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