Loading

How to get complete database from Server to the local machine?

Vijay Pratap Singh

I have a production database on the server. But I want to get that complete database in my local machine both Tables and SPs. How can I do that?
Note: I have tried using the SSMS Export service but I got only tables, not the SPs.
I have attached the SS of how I tried but I got only Tables. So I want to know the way I can get Tables and SPs both.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munib Butt4y ago
A full backup and restore would be the solution if you want the data as well. If not, you can script objects of type table and stored procedures and then run this script on your local machine. It will create the tables and stored procedures with no data.
0
George4y ago
You can use backup and restore if you have the access to the server, because the backup is always backuup into the server.

So, if you have the access to server, make a backup of the database, and copy the backup file into your local computer to make Restore. Then, done.
+1