Home Data How to copy D...

How to copy Database on another computer in MS SQL

0 2248

For the project development we use DATABASE for store the input to the develop system . Database also use to get the value of the particular element which enter the earlier.
When we develop the system we create the Database on the same system , but the problem occurs when we have to use the system on different system we are unable to copy the data base and unable to send  it Pen-drive.

Here, I’ll tell you how to use the same Database in the different system (Computer ) .
(For Microsoft SQL )
There are two method to copy the Database on another System(Computer).
  1. Only The Database Table Structure ( No Data Entry)
  2.  Copy the Whole Database With Structure as well as Data Entry.
Method 1.  Only The Database Table Structure ( No Data Entry): This is used when we want to give the whole Develop Software to the User, who come to us for the development of the software.
We generate the Scripts for the same database.
Follow steps given below for this method : 
Step 1: Open SQL Express and Login it .

Step 2. Now Right Click on the Database name which you want to copy on another.

Step 3: Go to the “Tasks ” Option .

Step 4: Now Click on the ” Generate Scripts…”.

Step 5: Now an window appears as:

Click Next.

Step 6: Now Your selected database appear , Check the ” Script all object in the selected database” and Click Next

Note: Database you want to copy must be selected

See The Below Image For E.g.

Step 7: Again Select Next, Now You having an option for “Script Mode” : Select the ” Script to Clipboard” option.

Click Next >

Step 8: Now, Click on ” Finish , After the processing completed , close the window

Step 9: Now Open the blank notepad file , Press ” ctrl + v ” and paste the all Script of the database and save the file .

Step 10: Now open the SQL on another computer where you want to copy the Database , First create the same name Database on the another computer .

Step 11: Now Click on the “New Query ” and copy the whole file “Which was created previous” and paste all the content in  the New Query and execute the Query.

Step 12 : Its Done , Now you can able to see the same Database Table in another computer.

Share It! Sharing Is Caring ………

Pawan Sharma (Vicky) is the founder of GetsUpdates.com . He Holds a B.tech Degree in CSE(Computer Science). As he always try to help people by applying some of his knowledge and tips, he always follow his tag line "Sharing is Caring" . Sharing knowledge will make it worthy. He is good in Logic's , and love to sing & listen to music , Apart from this, he have geek interest in "Chess" & "Logical Game".


Leave a Reply