Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    35

    Question Unanswered: What is the best way to compare db for ver 11.5?

    Hi Expert,


    We would like to move data from old machine to new machine. We are using Sybase 11.5 on NT platform. If we want to use bcp, how can we compare the destination db is the same as source database?

    Can BCP load data in several tables instead of one table at a time? I am quite new in sybase so i might not know the useful tools out there.


    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    1) bcp out the result of each table from the both servers and make a diff (on Unix, but I suppose that you will find a freeware tool comparing 2 files on NT)
    2) it's possible to bcp out (and in, with some restrictions) a table or a view. A view can be a select on several tables

    What is the source and what is the target ? if it's 2 ASEs on NT, why don't you simply dump/load the database from a server to an other ?

Posting Permissions

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