Dedicated database model and data

DwayneC

When working with the dedicated database model, you are working with a local database but what about the data. Does the local database contain schema information and a small subset of data?

David Atkinson

If the rest of the team want to have the same data the simplest option is to restore backups of the first database for each developer. This way everyone will have the same starting point.

David Atkinson

It's entirely up to you how you provision your dedicated databases. SQL Source Control won't mind. You can have full copies of production for each developer if you have the space. If you don't have the space, use SQL Clone to provision production-sized database for each developer at no additional storage cost. If you have sensitive data you might need to mask that either with your own scripts or with a tool like Redgate's Data Masker.

DwayneC

So, the person who initially commits the database to source control will be working with the database that contains data. Is that correct?

Then others who want to work with the same database will have to create a empty database, link to the repo in Git, and then do a get latest. Now, the database will be in sync with the original but does not contain any data. Is this correct?