Copy All Contents of a Table

• martin.edward

  SSCommitted

  Points: 1645

  More actions

  October 9, 2009 at 5:43 am

  #138553

  Hello,

  I have used the command below to copy data from a table in a database to another

  select * into MultiSports.dbo.TRACE1 from TrainingDB.dbo.OINV

  This moves the data only. I would like to move the indexes,statistics,triggers,keys,columns and constraints as well.

• TheRedneckDBA

  SSChampion

  Points: 14001

  More actions

  October 9, 2009 at 6:43 am

  #1064008

  You can either script them all out (SSMS will do that for you), or use the transfer wizard in SSMS.

  The Redneck DBA

• martin.edward

  SSCommitted

  Points: 1645

  More actions

  October 9, 2009 at 2:54 pm

  #1064365

  Thanks, but how exactly ?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  October 9, 2009 at 10:11 pm

  #1064419

  http://blogs.msdn.com/davidlean/archive/2009/09/20/tip-ssms-script-your-entire-table-including-the-data-a-hidden-gem.aspx

  MJ