About your SQL Server database releases Survey

Page1 / 6

Thank you for participating in our 10-minute survey on SQL Server database releases.

Your feedback will help us improve our tools.

All questions in the survey relate to databases specifically, eg. Database environments, objects and scripts etc. Please answer in relation to a project/product with which you are familiar, and is currently in production.

At the end you will be given a chance to enter an e-mail address to win a $50 Amazon gift certificate. Thanks again for helping with your answers!

Best wishes,

Justin Caldicott
Red Gate

Question Title

* 1. Which of the following environments do you have?

Development

Integration

Testing

UAT

Staging

Pre-production

Production

Other (please specify)

Question Title

* 2. If you have a staging/pre-production environment, how closely does it represent production? If you do not have a staging or pre-production environment, skip to the next page, Question 7.

Lots of differences

Some differences

Mostly identical

Completely identical

Question Title

* 3. When in your release process do you refresh staging/pre-production schema to match production?

We don't

Before staging deployments

After staging deployments fail to get deployed to production

After production deployments

Other (please specify)

Question Title

* 4. How do you refresh staging/pre-production schema from production?

Question Title

* 5. When in your release process do you refresh staging/pre-production data to match production?

We don't

Before staging deployments

After production deployments

Nightly

Weekly

Monthly

Other (please specify)

About your SQL Server database releases

Environments

Question Title

* 1. Which of the following environments do you have?

Question Title

* 2. If you have a staging/pre-production environment, how closely does it represent production? If you do not have a staging or pre-production environment, skip to the next page, Question 7.

Question Title

* 3. When in your release process do you refresh staging/pre-production schema to match production?

Question Title

* 4. How do you refresh staging/pre-production schema from production?

Question Title

* 5. When in your release process do you refresh staging/pre-production data to match production?

Question Title

* 6. How do you refresh staging/pre-production data from production?

Question Title

* 1. Which of the following environments do you have?

Question Title

* 2. If you have a staging/pre-production environment, how closely does it represent production? **If you do not have a staging or pre-production environment, skip to the next page, Question 7.**

Question Title

* 3. When in your release process do you refresh staging/pre-production schema to match production?

Question Title

* 4. How do you refresh staging/pre-production schema from production?

Question Title

* 5. When in your release process do you refresh staging/pre-production data to match production?

Question Title

* 6. How do you refresh staging/pre-production data from production?

* 2. If you have a staging/pre-production environment, how closely does it represent production? If you do not have a staging or pre-production environment, skip to the next page, Question 7.