Post reply

backup 6.5 restore to 7

  • April 8, 2005 at 9:49 am

    #165069

    is it possible to backup up a db on 6.5 and restore it to 7? If so, can someone please provide me with the exact syntax.

    thanks

  • April 8, 2005 at 10:35 am

    #551612

    Absolutely not.

    SQL 6.5 is a totally different architecture to SQL 7 and onwards.

    SQL 6.5 is nearer to SyBase on UNIX than it is to SQL 7 on Windows.

    You can connect a SQL 7 database to a SQL 2000 server though.

    Your options are

    1. Data Transformation Services (DTS)

    2. BCP

    DTS will require a direct connection between your SQL 6.5 and SQL 7 box. I used to do this regularly to bounce data from a clients SQL 6.5 box into our SQL 7 datamart.

    I've not used BCP for ages, but it used to be a blazingly fast input/output mechanism for data.

    LinkedIn Profile

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply