import & export wizard (SSID)

• sepp-914389

  SSC Rookie

  Points: 31

  More actions

  October 19, 2008 at 4:38 am

  #124412

  Hi,

  i need to copy data from one database (Latin1_General_CI_AS) to the same but (SQL_Latin1_General_CP1_CI_AS). the standard wizard does not allow me to set delete rows in destination table and enable identity insert.

  Can this be done?

  Or can I change the collation during database copy?

  Thank You

  Sepp