how to copy one database to another in sql server

Question

hello Everyone,how to copy one database to another db in same machne..plz tell me? :)

Rajeesh Menoth · Answer

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

Rajeesh Menoth · Answer

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 ..!!

Raja T · Answer

Hi Arvind, Please checkout below links http://serverfault.com/questions/547005/how-to-copy-sql-server-database-on-same-server http://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp http://blog.sqlauthority.com/2011/05/27/sql-server-copy-database-from-instance-to-another-instance-copy-paste-in-sql-server/

Jignesh Trivedi · Answer

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.

Sourabh Somani · Answer

Arvind Chourasiya · Answer

Actually i want it from management studio only but from through query. not from database->task->GenerateScript not like that.Sorry for confusing Sourabh.

Arvind Chourasiya · Answer

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

Arvind Chourasiya · Answer

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.

how to copy one database to another in sql server

Answers (8)