Copy data from one schema to another

• SmilingLily

  SSC Eights!

  Points: 920

  More actions

  February 12, 2015 at 8:24 am

  #295326

  Hi - I have a database DB1 and DBTest

  DBTest Database is empty. I want to copy all the objects in DB1 - schema1 how can I do that?

• Bhushan Kulkarni

  SSCrazy

  Points: 2829

  More actions

  February 12, 2015 at 8:32 am

  #1777265

  You can use cross database reference in the query, something like this...

  USE TestDB

  GO

  INSERT INTO Table1

  SELECT * FROM DB1.dbo.Table1

  Do this for all tables one by one.

  Or your database is small the you can refer this link

  http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  February 12, 2015 at 8:38 am

  #1777268

  SmilingLily (2/12/2015)

  ---

  Hi - I have a database DB1 and DBTest

  DBTest Database is empty. I want to copy all the objects in DB1 - schema1 how can I do that?

  backup and restore the database would be the most obvious

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉