Results 1 to 2 of 2

Thread: Replication

  1. #1
    Join Date
    Aug 2003
    Location
    Canada
    Posts
    7

    Unanswered: Replication

    New to sybase!!!

    I have a database that is being replicated to another, and I'm planning to create an index on one of the source database tables. Do I need to shutdown replication before doing that? and do I need to create the index in the destination database manually?

    Thanx

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    1) normal replication : you can create your index without stoping the replication. You can create in in the primary, replicated or both sides.
    2) Warm standby replication : the creation of the index must be done on the primary. The RS will replicate the DDL 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
  •