Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81

    Unanswered: Transfer DB from 11.9 to 12.5

    Hi,

    I have to transfer a database from 11.9 under Solaris to 12.5 under AIX.
    Can I just dump it to file on one computer and restore on another ?

    Another question regarding backup:
    I get the following from ISQL:

    1> dump database users to "/tmp/sybase_users_db.bak"
    2> go
    Msg 7205, Level 17, State 2:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
    Msg 7205, Level 18, State 3:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.

    And that's what the log says:
    00:00000:00007:2003/08/27 16:16:00.44 kernel Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
    00:00000:00007:2003/08/27 16:16:00.49 kernel Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
    00:00000:00007:2003/08/27 16:16:00.49 server Error: 7220, Severity: 11, State: 1
    00:00000:00007:2003/08/27 16:16:00.49 server Site 'SYB_BACKUP' not found in interfaces file.
    00:00000:00007:2003/08/27 16:16:00.50 server Error: 7235, Severity: 17, State: 0
    00:00000:00007:2003/08/27 16:16:00.50 server No other query entry found for the remote server SYB_BACKUP - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.

    Please help me to backup this database.
    Thanks.
    --
    kukuk

  2. #2
    Join Date
    Aug 2003
    Location
    South Africa
    Posts
    10

    Re: Transfer DB from 11.9 to 12.5

    Regarding the transfer from 11.9 -> 12.5:
    Dumping from 11.9 and loading it into 12.5 should work fine as we do it from 11.5.1 -> 12.5. When you issue the online database command - the dataserver itself does the necessary rebuilding/upgrading of the system tables for that database.

    Things to look out for are - we've found some triggers needed to be recreated manually, as well as some stored procs. So far we haven't had any issues wrt indexes.

  3. #3
    Join Date
    Jun 2003
    Posts
    15

    Re: Transfer DB from 11.9 to 12.5

    Originally posted by kukuk
    Hi,

    I have to transfer a database from 11.9 under Solaris to 12.5 under AIX.
    Can I just dump it to file on one computer and restore on another ?

    Another question regarding backup:
    I get the following from ISQL:

    1> dump database users to "/tmp/sybase_users_db.bak"
    2> go
    Msg 7205, Level 17, State 2:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
    Msg 7205, Level 18, State 3:
    Line 1:
    Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.

    And that's what the log says:
    00:00000:00007:2003/08/27 16:16:00.44 kernel Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
    00:00000:00007:2003/08/27 16:16:00.49 kernel Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
    00:00000:00007:2003/08/27 16:16:00.49 server Error: 7220, Severity: 11, State: 1
    00:00000:00007:2003/08/27 16:16:00.49 server Site 'SYB_BACKUP' not found in interfaces file.
    00:00000:00007:2003/08/27 16:16:00.50 server Error: 7235, Severity: 17, State: 0
    00:00000:00007:2003/08/27 16:16:00.50 server No other query entry found for the remote server SYB_BACKUP - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.

    Please help me to backup this database.
    Thanks.
    Regarding backup--
    It doesn't appear that the backup server has been configured and/or brought up. Check to see if you have a RUN file for the backup server in the install directory. Start the backup server if it exists and retry your command. Otherwise you will need to condfigure and start a backup server.

Posting Permissions

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