Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    11

    Unanswered: db migration from 11.92 to 12.5

    Currently i have a sybase db on Syb 11.92, I have another server with 12.5 on it. What is the best way/path to take in migrating that databse from the 11.92 server to the 12.5 server?

    Thank you
    D

  2. #2
    Join Date
    Jan 2003
    Posts
    17

    Re: db migration from 11.92 to 12.5

    Easiest way would be to do a dump/load (assuming the platforms are the same)


    -Carl

    Originally posted by dhooper
    Currently i have a sybase db on Syb 11.92, I have another server with 12.5 on it. What is the best way/path to take in migrating that databse from the 11.92 server to the 12.5 server?

    Thank you
    D

  3. #3
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: db migration from 11.92 to 12.5

    Originally posted by cdotger
    Easiest way would be to do a dump/load (assuming the platforms are the same)


    Ensure databases pass dbcc checkalloc and dbcc checkdb before migration
    Drop and recreate procs after migration
    Run dbcc upgrade_object
    Update Stats

Posting Permissions

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