How can we improve SQL Source Control?

Full Text Indexes cause process to fail

I think the ordering of the build process needs to be addressed. When I get latest on a local machine it looks like stored procedures are being added before the full text indexes they reference. Currently I am having to de-select any referencing objects, apply the full text indexes and then re-select the objects to be applied. Is there any chance this can be addressed in a future patch?

66 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Mike BirkettMike Birkett shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • db_braddb_brad commented  ·   ·  Flag as inappropriate

        This is a deal breaker for us. If this is not fixed soon or some type of workaround presented, we can't go with this tool. Would love to, this is by far my favorite option.

      • IanIan commented  ·   ·  Flag as inappropriate

        I agree - why do the build in an order that is going to fail? If it's because they cant be done transactionally, then just do them at the start of the script and it it fails, abort the rest of the script.

      Feedback and Knowledge Base