Results 1 to 14 of 14
  1. #1
    Join Date
    Oct 2006
    Posts
    12

    Unanswered: Snapshot tables in Sybase??

    Hi,
    In Oracle database, one can create snapshot tables. Is there a similar thing in Sybase. We want to have a copy of a table from database-A on database-B and the copy on database-B should be refreshed automatically.
    Thanks

  2. #2
    Join Date
    Oct 2006
    Posts
    12
    btw, we do not want to use proxy tables. Is there any other alternative??
    Thanks

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    I assume the 2 databases are on different servers
    And refresh snapshot I take to mean
    you want a refresh at certain intervals e.g. daily
    Then schedule a bcp job via unix crontab

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Use ASE Replicator and subscribe to the table. ASE replicator is a freebie replication product

  5. #5
    Join Date
    Jul 2006
    Posts
    115
    Quote Originally Posted by willy_and_the_ci
    Use ASE Replicator and subscribe to the table. ASE replicator is a freebie replication product
    I hv some questions on ASE Replicator:
    1. can ASE Replicator work across sybase server?
    2. how ASE Replicator performance in term of transaction processing?
    3. what sybase version provide this free ASE Replicator ? 12.5.0.1?


    thx

  6. #6
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    1. Yes - replicator can work between databases on the same server, or between servers.
    2. Never used it under anything but very low load - maybe someone else has better information.
    3. I don't remember which version of 12.5 first included Replicator, but it's been around for a while. I'm pretty sure that this was before 12.5.1.

    Michael

  7. #7
    Join Date
    Jul 2006
    Posts
    115
    Quote Originally Posted by mpeppler
    2. Never used it under anything but very low load - maybe someone else has better information.
    Michael
    is it mean that it cant be used in non-busy server? can you explain more?

    thx

  8. #8
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    yeah.. it is alright for a single connection, but don't expect the data to be at real time. The configurable and performance tuning parameters are also limited in Replicator.

    For what you are trying to achieve (a single table subscription), replicator is pretty handful.

    It was first introduced in ASE 12.5.0.1. All I can say about it is that "it works".

  9. #9
    Join Date
    Jul 2006
    Posts
    115
    thx .. not real time is ok ... how about 10 tables subscriptions? also will the Replicator affect the source database performance?

  10. #10
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Replicator is good for 10 tables.

  11. #11
    Join Date
    Jul 2006
    Posts
    115
    thx, but
    1. does sybase set any no of table limitations in replicator? in fact, i want to replicate many sybase tables (as many as it can ... about 50 tables ...)
    2. will it affect the source database performance too much especially in term of blocking and locking?

  12. #12
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    There is no hard limit on number of tables.
    It runs a dbcc logtransfer on the source run at the lowest execution class. There is NO noticeable impact in the primary.

  13. #13
    Join Date
    Jul 2006
    Posts
    115
    Quote Originally Posted by willy_and_the_ci
    There is no hard limit on number of tables.
    It runs a dbcc logtransfer on the source run at the lowest execution class. There is NO noticeable impact in the primary.

    thx willy ... it's very useful..

  14. #14
    Join Date
    Jul 2006
    Posts
    115
    one more question. how about "nonlogged" transaction e.g "truncate table ... etc ? will it replicate to target db too?

Posting Permissions

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