Our Training Programs

All contents are copyright of their authors.

Hi, how to copy all the shema and data from from prod to dev instance?

Hi, how to copy all the shema and data from from prod to dev instance?

Prajwal Kp

5yAsked Jul 2, 2021, 5:47 PM674Learn iOS Programming

Hi,
how to copy all the shema and data from from prod to dev instance?

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Rajanikant Hawaldar5y ago
Accepted answer
Making a backup and restoring that in dev, for example. And think about, that developers shouldn't have access to customer data on dev. And no, it's not done with just a copy. You need to have a workflow in place, and so on and so forth.
Satya Karki5y ago
You can do backup and restore.
check my this article.
https://rijsat.com/2021/03/24/what-is-database-restore-and-create-options-how-to-export-bacpac-using-ssms/
Rijwan Ansari5y ago
Hi,

You can do export and import.

Backup/Export Options:

https://rijsat.com/2021/03/24/what-is-database-restore-and-create-options-how-to-export-bacpac-using-ssms/

Import

https://www.c-sharpcorner.com/article/how-to-import-or-restore-bacpac-file-from-ssms/