generate script a database and load another one

• sa.ordekci

  Ten Centuries

  Points: 1177

  More actions

  February 10, 2012 at 6:33 am

  #268080

  Hi. i want to generate scripts of a database and then i load this script to another db. i do generate scripts. ow can i load this another db.

  Thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  February 10, 2012 at 7:27 am

  #1445551

  At the beginning of the script, put

  USE [OtherDatabase];

  This will change the scope of the script to the other database. Make sure the script doesn't contain other USE statements that change the scope back.

  This will only work when the two databases are on the same server.

  Alternatively, you could just select the other database in the dropdown at the SSMS toolbar.

  If the other database is at another server, you need to change the connection.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP