Exporting Index

• binu.m.a

  SSC Enthusiast

  Points: 127

  More actions

  November 12, 2007 at 10:13 pm

  #121106

  Hi

  I have a table with clusterd and nonclustered index. I want to export this table to a different server with all of these indexes.Kindly help me

  Binu

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 13, 2007 at 12:30 am

  #750492

  1) Using SSMS generate scripts to create table and indexes.

  2) Run the scripts in the other server.

  3) Export the data.

• binu.m.a

  SSC Enthusiast

  Points: 127

  More actions

  November 13, 2007 at 12:38 am

  #750494

  Thanks

  Binu

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 13, 2007 at 12:43 am

  #750497

  Welcome.