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).
- Only The Database Table Structure ( No Data Entry)
- 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:
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 ………