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

• 

  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 July 24, 2019 21:49

  - 0 +
• 

  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!

  Mac_F July 25, 2019 16:35

  - 0 +

Add comment

Please sign in to leave a comment.