How to copy Database on another computer in MS SQL
- Only The Database Table Structure ( No Data Entry)
- Copy the Whole Database With Structure as well as Data Entry.
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 ………