Sql 2008 Database

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  January 16, 2009 at 1:27 pm

  #204151

  Hi,

  I have 5 different databases in sql 2008.

  I want to make one database which i can copy all the 5 databases into this new single database.

  I have no clue about it.

  thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 17, 2009 at 9:24 am

  #928689

  Create the database and use the migration wizard to move each table/view/proc/function into it.

  Use different schemas if needs be

  ---

  
  Shamless self promotion - read my blog http://sirsql.net