Hi Guys
We use RedGate SQLCompare over the cmd line to update our databases everyday.
Ive added a column to an existing table that doesn't allow nulls and has a default value of 1.
The FK for this column is to a new lookup table with static data.
When SQLCompare updates our database it tries to add the column and default value before adding the new lookup table and so the FK breaks and the update fails![Frown :( :(](/styles/default/xenforo/vbSmilies/Normal/frown.gif)
Anyone have any experience with this?
Is some kind of pre migration the only way around this?![Frown :( :(](/styles/default/xenforo/vbSmilies/Normal/frown.gif)
thanks!
We use RedGate SQLCompare over the cmd line to update our databases everyday.
Ive added a column to an existing table that doesn't allow nulls and has a default value of 1.
The FK for this column is to a new lookup table with static data.
When SQLCompare updates our database it tries to add the column and default value before adding the new lookup table and so the FK breaks and the update fails
![Frown :( :(](/styles/default/xenforo/vbSmilies/Normal/frown.gif)
Anyone have any experience with this?
Is some kind of pre migration the only way around this?
![Frown :( :(](/styles/default/xenforo/vbSmilies/Normal/frown.gif)
thanks!
Last edited: