Commiting only my changed DATA in shared database.

dsol · April 15, 2019 1:11PM

HI,

I have a shared SQL database being used by multiple developers. i have linked this database to a github on my local machine using SQL Source Control. I have a table setup to be tracked for any data changes. Now this table is used by multiple developers and they make changes to this table. when i try to commit any data changes to my local git , the (insets/updates) by other developers are also committed to my local git. is there a way ,where i can get option to select only the rows which i want to commit (like the interface i get using SQL Data compare).

I can't change my settings from shared DB to dedicated DB, since my source control is linked to GIT.

Any Suggestions ??

Rachel A · April 18, 2019 10:05AM

First off, don't use a Shared database - if it's shared then, yes, Sql Source Control will see other folks changes and commit them to your git. Unsure how else you think it's meant to work here since data is, well, data...

Secondly, you can always unlink and relink using a different model - however I'd strongly advise myself you not use a dedicated model on a shared database.

Best I can suggest for things like this is perhaps have a table per developer with the requisite data and use either a post-deployment script or some other mechanism to then 'merge' this data into the main table...

Eddie D · April 29, 2019 10:44AM

Hi dsol, thank you for your forum post.

I can only agree with Rachel A. You need to be using the dedicated model, as each developer works on their own separate copy of the database.

https://documentation.red-gate.com/soc7/sql-source-control-for-teams/teams-using-the-dedicated-model
https://documentation.red-gate.com/soc7/sql-source-control-for-teams/teams-using-the-shared-model

Many Thanks
Eddie

Commiting only my changed DATA in shared database.

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk