how to copy one database to another in sql server

Hi Arvind, Please checkout below links

 

Hi,

you can also restore the database from exsting data by using SQL query.

Please refer

https://msdn.microsoft.com/en-IN/library/ms186390.aspx

https://msdn.microsoft.com/en-us/library/ms189624.aspx

 

 

other option please refer

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/ 

hope this will help you.

iwant db copy from query/manually not from wizard or management studio..if anyone have idea plz share:) 

Hi,

 

There are several ways to do this, below are two options:

Option 1 - Right click on the database you want to copy

• Choose 'Tasks' > 'Generate scripts'

• 'Select specific database objects'

• Check 'Tables'

• Mark 'Save to new query window'

• Click 'Advanced'

• Set 'Types of data to script' to 'Schema and data'

• Next, Next

You can now run the generated query on the new database.

Option 2

• Right click on the database you want to copy

• 'Tasks' > 'Export Data'

• Next, Next

• Choose the database to copy the tables to

• Mark 'Copy data from one or more tables or views'

• Choose the tables you want to copy

• Finish

 

 

Reference :

 

http://www.codeproject.com/Tips/664327/Copy-Table-Schema-and-Data-From-One-Database-to-An 

Thank you, 

 But Actually Rajeesh we want it through query,and here u r copying table wise,so our task is selecting /copying one db to another by using query only.

Hi,

 

In the following article provide the steps.you just check the following reference.In that article image showing on "Set Scripting Option" that option contain "Advanced" section so just click on the particular option and change the database like 2008,2012,etc

 

Check this Reference :

 

http://www.c-sharpcorner.com/UploadFile/rohatash/copy-table-with-data-from-one-database-to-another-in-sql-ser/

 

The answer is helpful.Then please accept it..!!