How to Syncing the staging databases with the Production as per the developers requirement

Question

How to Syncing the staging databases with the Production as per the developers requirement

naga.rohitkumar

SSCertifiable

Points: 5742
More actions
September 18, 2014 at 11:13 pm

#148677

HI all,
How to Syncing the staging databases with the Production as per the developers requirement..
Thanks
Naga.RohitKumar
Thanks
Naga.Rohitkumar

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 1

There are a couple of ways to do that. How big are the databases? If not too big, then backup and restore the production database onto the development database.

naga.rohitkumar SSCertifiable Points: 5742 More actions · Answer 2

Thanks for your reply

If the Database size is more than 2tb then what should we do?

Thanks

Naga.Rohitkumar

Thanks
Naga.Rohitkumar

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

With staging databases, do you mean "development" databases?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

naga.rohitkumar SSCertifiable Points: 5742 More actions · Answer 4

naga.rohitkumar

SSCertifiable

Points: 5742

September 19, 2014 at 3:09 am

#1746624

yes

Thanks
Naga.Rohitkumar

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 5

Copy the schema but not all of the data.

For example only last month.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

naga.rohitkumar SSCertifiable Points: 5742 More actions · Answer 6

how to copy schema and how can we select the data only for last month

Thanks
Naga.Rohitkumar