Dedicated database model and data

DwayneCDwayneC Posts: 2 New member
in SQL Source Control
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?
Tagged:
· Share on Twitter

Best Answer

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Answer ✓
    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
    Product Manager
    Redgate Software
    · Share on Twitter

Answers

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    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.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • DwayneCDwayneC Posts: 2 New member
    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?
    · Share on Twitter
Sign In or Register to comment.