How to copy a MS SQL database on another computer

DATABASE project for the development of our stores to develop a system for the input. The database is also used to get the value of a specific element previously entered.


Create a database on the same system, we developed a system, but we can not be copied from another system database and send the pen drive can not be used when the system problem occurs.



Now, I will tell you how to how other systems (computers) that use the same database.
(Microsoft SQL) for
There are two ways how to copy the database to the other system (computer).
The database only the table structure (data entry)
Structure, as well as data entry, copy the entire database.
Method 1. The database only the table structure (data input): We come to us for the entire software development to develop software to provide the user when it is used.


We generate a script for the same database.
This way, follow the steps given below:


Step 1: Open SQL Express.

Step 2. Now, you click the name of the database you want to copy to other.



Step 3: Go to the "Tasks " Option .



Step 4: Now Click on the " Generate Scripts...".


Step 5: Now an window appears as:



And then click Next.



Step 6: The selected database appears click "OK", and then all the objects in the script to the selected database.

Note: to be copied, select the database must


See image below for example:



Step 7: Re-select the next "script mode" option: the option script "clipboard".






Click Next>



Step 8: Now, When the processing is complete, Click Finish to close the window



Step 9: You should now see a blank Notepad to open the file by pressing "Ctrl + V" and paste the database script and save the file.



Step 10: At first you copy the database SQL to create a database of the same name on a different computer to another computer, open it.




Step 11: Now click on "new query" and "previous generation" to copy the entire file and paste all the contents a new query and run.



Step 12: it's complete, now from another computer to the same database table can be seen.



Share it! Sharing gentle .........