Reference Data Manager

ZeOmega

We are keeping our database code in source control based on state. We also have redgate's toolbelt purchased. Currently we are packaging reference data (static) using multiple files for each table and calling it in post deployment script. While research we found one of the blog says redgate is building a visual studio extension to add reference data in state based management of code. Would it be possible to get the VS Extension and what would be the pricing for it. 

PeterG

Hi,

If you are using Redgate's SQL Source Control to manage your state then we already have static data supported - https://documentation.red-gate.com/soc6/common-tasks/link-static-data
Or if you are using Redgate's SQL Change Automation in Visual Studio then you can also use static data - https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-scripts-to-capture-database-changes/data-population/static-data

If you are talking about the SSDT extension we were looking into then that did not get out of the research phase.

ZeOmega

Thank you a lot for the reply