Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Norway
    Posts
    5

    Question Unanswered: synchronise two tables

    Hi ,

    i am using sybase 6.03 (though we might be shifting to sybase 9 soon).

    my problem is as follows:-
    i have two databases.
    both databases have same structure.

    however database A is frequently updated. while B is not.

    what is the best way to synchronise database B with the changes done in database A.
    i need to synchronise only a few tables.

    is there a fast method ? or will i have to transfer all data and input it into database B

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    If this will be an ongoing thing, then one option is to look at using Replication using SQL Remote.

Posting Permissions

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