Ways to move data

Question

What are the different ways to move data from one DB to another in MS -SQL ?

Gowtham K · Answer

Hi San Refer this http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/ 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/ http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Vinay Singh · Answer

You can move databse 1. by taking backup and restoring the DB at new lovation 2. By taking script of whole DB and run it on new location 3. user SQL import to move DB for detail check the link https://support.microsoft.com/en-us/kb/176909