SQL Server Performance

Indexes for Replication DB

Discussion in 'SQL Server 2005 Replication' started by aruud12, May 19, 2006.

  1. aruud12 New Member

    We are migrating from Oracle 10g to MS SQL Server 2005. We have setup replication between the Oracle and MS SQL servers. All is well except I need to get all the indexes created on the MS SQL DB.


    I have also converted a static DB using the Microsoft Migration Assistant, so the indexes are located on MS SQl also.

    Does any one have a process that I can capture the Oracle DB Schema Indexes and apply them to the MS SQL DB. Or a way to capture all the indexes from the static DB on MS SQL and apply them to the Replicated DB?

    Thank you,
    Alan
  2. satya Moderator

    As far as my Oracle knowledge is concerned that is not possible to persuade indexing schema between Oracle & SQL server.

    On SQL server you can script out the Indexes in order to apply the same on similar database schema, refer to the SQL books online about Generating SQL Scripts or take help with Wizards on SSMS.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page