Copy all objects from one server to another server

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  August 12, 2015 at 7:40 am

  #398887

  Using import task only can select and copy tables and views.

  Since there are many objects at the same DB I don't need copy, is there any way let me select and copy some objects, such as functions, stored procedures?

• BrainDonor

  SSCoach

  Points: 19256

  More actions

  August 12, 2015 at 8:25 am

  #1819330

  In SSMS, right-click on the database and select Tasks/Generate Scripts.

  Steve Hall
  Linkedin
  Blog Site