Help with major refactor
We did a major refactor on our database, and I'm having trouble getting redgate to cooperate.
Essentially, we something like this:
Table1
Table2
TableWhichReferencesTable1
Table1ID
What happened was
Table1 -> Table2
Table2 -> Table3
TableWhichReferencesTable1
Table2ID
As you can see a real mess. I wrote (by hand) a custom migration script, and told redgate it was for all those tables in questions.
When I try to deploy, I get an error that Table3 is already defined.
Essentially, we something like this:
Table1
Table2
TableWhichReferencesTable1
Table1ID
What happened was
Table1 -> Table2
Table2 -> Table3
TableWhichReferencesTable1
Table2ID
As you can see a real mess. I wrote (by hand) a custom migration script, and told redgate it was for all those tables in questions.
When I try to deploy, I get an error that Table3 is already defined.
Comments
Thanks for contacting us and sorry you are having this issue!
Here is some documentation on correctly setting up migration scripts https://documentation.red-gate.com/disp ... t+examples
I will follow up with you via email for more info!
Warmly,
Technical Sales Engineer
Redgate Software