How static data is working for SQL Server

moattarwork

Due to the documentation, the static data is available in the preview but is working for SQL Server, however, I'm struggling to get this to work as changing the static data doesn't cause anything in the migration tab as it is described in the documentation. 
I'm wondering if I have missed something so look forward to any suggestion

DanC

Hi @moattarwork

There's two potential areas where an issue might be coming from.

Failing to meet the prerequisites
In order for SD to show up in the tab as you mention, the table the data is in must already have been committed and the data must have a defined primary key, if either of these criteria are not met, it will not show up, even if the configuration is otherwise correct.

Configuration
It's possible that your JSON file isn't configured correctly, would you be able to share this file? 

If you'd prefer I can reach out via a support ticket if you'd prefer to share privately