Vijay Pratap Singh

Vijay Pratap Singh

  • 325
  • 5.1k
  • 468.2k

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

Aug 9 2022 2:15 PM

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.


Answers (2)