[Tuesday, December 07, 2010]

Here's a really simple way to copy a table from database to another. I often get the syntax slightly wrong and have to look it up so here it is. Of course I'll probably never need to look it up again now that I've written it down!

Important: this doesn't copy indexes, keys, etcetera so don't forget about those.

SELECT * INTO DestinationDB.dbo.tblTable1 FROM SourceDB.dbo.tblTable1

Posted by: Benjamin Felt

Search

Recent Posts

  1. SQL Job History
  2. Check for existence of temp table
  3. Merge - Conditionally Insert, Update, or Delete
  4. Copy Table
  5. Deleting Duplicates
  6. Deactivate Autorecovery
  7. MS SQL "Stuff" Keyword
  8. MS SQL Cursor
  9. MS SQL Row Count