Is there a way to share changing/non-static data in SQL Source Control?

ixs1022

Hello,
My team is working to move to SQL Source Control using a dedicated setup. Currently we have a shared setup and we share data for our application which in our development database is able to be edited at any time. Is there a way to share all the changing data (not just the static data) with SQL Source Control? Or any suggestions on how we can share non-static data?
Thanks!

Mac_F

Hi,

Unfortunately, you would not be able to use SQL Source Control for non-static data. Instead, this would be a job for SQL Data Compare!

Here is a link to a worked example for deploying data to two databases using SQL Data Compare: https://documentation.red-gate.com/sdc13/worked-examples/worked-example-deploying-data-in-two-databases

I hope this helps.

Kind regards,

Mac_F

Hi,

As a follow up to my previous post, I wanted to update you on another option available for your situation.  

Redgate's SQL Clone would be the official recommended way to create dedicated dev databases. 

This would be the preferred way to create a common data image, and the creation of clones off this should be a way of getting the same dataset to Devs without much overhead.

Here is a our SQL Clone page that gives you an overview of how it works: 

https://www.red-gate.com/products/dba/sql-clone/

And this page is our documentation on how to get started using it:

https://documentation.red-gate.com/clone3/getting-started/what-is-sql-clone

Thank you!