Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006

    Unanswered: database load problem from ase11.5 to ASE15

    Hi all

    I am working on ASE 15 under Linux , i have created database for load on ASE15 but while load complete error occurs 1412,3454 etc

    plz help me

  2. #2
    Join Date
    Jun 2006
    load it to 12 or 12.5 then dump and load
    11.0.3-->15 not supported, i believe

  3. #3
    Join Date
    Jan 2003
    Geneva, Switzerland
    First make sure that the source database is free from any corruption.

    Once that is done you should be able to load the 11.5 dump to your 15.0 server.


  4. #4
    Join Date
    Jul 2006

    upgrading to ase15

    run dbcc first on database before dump
    i think that you need to extend your data , log devices with 10% over, because ase15 devices has extra size.

    solution2- migration using devices:
    i applied that approach when migrating ase12.5 to ase15- try it

    1-Quiesce the database to a manifest file
    quiesce database for_upgrd hold testdb
    for external: dump to “d:\data\db_manifest.mfst” with override

    2-Copy the devices using disk copy commands, or file explorer to the new destinatin.
    3- When the device copy is finished, release the quiesce by a SQL statement similar to:
    quiesce database for_upgrd release
    4- If this is the final upgrade , shutdown old ASE to prevent further changes.
    5- Move the device copies to the new host machine and mount them using mount command(for more detail see ref manual).
    Last edited by moh_hassan20; 07-01-06 at 17:09.

  5. #5
    Join Date
    Jul 2006
    I suggest reading technical note from sybase , published in Mar 27, 2006 , title:
    "Urgent from Sybase: Possible data integrity issue when loading a database from a dump, affecting versions of Adaptive Server Enterprise 15.0, 12.5, and earlier"
    at url:
    M. Hassan

Posting Permissions

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