Performing Bulk Copy Operations on Database

There can be situation when we need to copy large amount of data from one location to another. For example,  you have created a backup copy of a table. Accidently, the records  of the original table get deleted. For this, we need to copy all the records from the backup table to the original table.
Most of the database server provides a means to copy data to one database to another, either by a GUI such as SQL Server's Enterprise Manager, or through a command-line tool, such as SQL Server's Bulk Copy Program -  bcp.exe.

Read More...

I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

Database, Bulk OPerations