How to copy data (rows) from one database to another

by Jagadish Pulakhandam on 9/22/2011 2:34:51 PM
Rated 0 from 0 votes
Brief: Demonstrates on copying data from one database to another (in this case, to another database in another instance)
Posted to: Microsoft SQL Server - Quick Learn ("How to"s for Developers)
Add to DiggAdd to del.icio.usAdd to FURLAdd to RedditAdd to YahooAdd to BlinklistAdd to GoogleAdd to ma.gnoliaAdd to ShadowsAdd to Technorati

Attached video demonstrates the following:
  • Using "Export Data" feature in SQL Server Management Studio
  • Copying data from one database (in one SQL Server instance) to another database (in another SQL Server instance)
NOTE:  This process can be applied for within the same SQL Server instance as well.

NOTE:  When copying the data, even though it creates new tables, it does not create any PKs or FKs or indexes.  It copies only rows (and creates tables with structures if they do not exist, but not other db objects). It is our responsibility.

Join the .NET Code Central Community and join the discussion!
Signing-up is FREE and quick. Do it now, we want to hear your opinion

Rated 0 from 0 votes ( login  to rate)
DotnetKicks DotnetKicksDe DotNetShoutout

Video/Screen Recording (may not have audio narration/annotations)
You need to Login or Join for FREE to download the following