Migration script to handle non static table

firasr

Hi,

I have the following scenario:
1. Currency is a static/lookup table controlled by SQL Source Control.
2. Product is a non static table with a foreign relationship to Currency table. It's already filled with records in production environment.

What I want to do is to delete some records from Currency table which already referenced by Product table.

How can I do that, do I need to write a migration script that handle Product table first (change currency for example), commit the task, then commit another task which updates Currency table?

Is it an acceptable solution to use the migration script in this way?

Thanks

Sergio R

Hi,

Yes, the procedure you describe on your post should work.

As a side note we recommend deploying from Source Control to production using SQL Compare, rather than using SQL Source Control directly.

Thank you,