Post reply

Moving Tables & Indexes

  • June 10, 2008 at 3:28 pm

    #75232

    Hi,

    We had a 7 production server's which are commmunicated through linked servers. Prod Server A is the main Hub Sever and the rest of the servers B,C,D,E,F use most of the tables and Db's from the Server A. So, we thought of moving some of the most frequently used table's(around 15 Tables) from Server A to all other Servers B,C,D,E,F etc. I know we can move the tables through DTS. But how can we move the indexes from these tables. I know we can script the indexes and run at the new location . But is there any other way to create all the indexes. And how do we transfer the SP's.

    Any Suggestions...Thanks

    Rahul

  • June 10, 2008 at 4:51 pm

    #827004

    kaykay005 (6/10/2008)

    But how can we move the indexes from these tables. I know we can script the indexes and run at the new location . But is there any other way to create all the indexes.

    Scripting is the way to go. I believe that all of the other ways actually use scripting under the hood.

    And how do we transfer the SP's.

    Again, script them.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply