How can we help you today? How can we help you today?

Unable to generate migrations scripts

When I attempt to generate migration scripts (immediately after a Refresh), I see a dialog box that says "One or more migrations have changed. Perform a refresh before importing". I'm simply attempting to add an index on a previously created table.

I also note that the refresh tells me that I need to "Add to Project' for many stored procedures and views that have existed in the project for quite some time (no changes to those have been made).

Can you please guide on how to resolve this?

Pam
0

Comments

2 comments

Sort by
  • Sergio Rocha
    Official comment

    Hi Pam,

    I would suggest trying the following:

    1 - Drop the Shadow Database and then refresh: this should force a rebuild of the Shadow Database

    2 - If the above doesn't work and assuming that you are using the default Programmable Objects option (UseRepeatableScriptsForAllObjects), delete the scripts for all the problematic Views and Stored Procedures and add them again

    Sergio Rocha
  • Pam

    Hi-- Prior to getting your suggestions, I did try both. Neither worked. The ultimate issue appears to be that one of my scripts was referencing another database (unavailable to the Shadow) even though I had configured the project to ignore these references. I have not found a workaround for this and have had to kludge this stored procedure's deployment to make SCA happy. 

    Would have been SOOooooo much easier to track this down if the error reported actually described what the issue was. In fact, SCA's behavior led me down several incorrect paths and displayed erroneous information after Refresh, causing much angst in the midst of a very important hypercare fix. :(

    Thanks for your response. I believe we can call my specific issue closed.

    Pam
    0

Add comment

Please sign in to leave a comment.