What are the challenges you face when working across database platforms? Take the survey
Options

Dedicated database model and data

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:

Best Answer

  • Options
    David AtkinsonDavid Atkinson Posts: 1,451 Rose Gold 2
    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

Answers

  • Options
    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
  • Options
    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?
Sign In or Register to comment.