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

Bug: Deploy script does not include extended properites

I am changing the definition of 3 indexes. They all have extended properties for MS_Description. When SQL Compare (10.3.8.406) builds the deployment script, it drops, then creates the indexes. That is fine, but it does not add the extended properties back. I have to manually adjust the deployment script to add the indexes back.

My project settings are not set to ignore extended properites (i.e. the box is unchecked). And the 3 extended properties do exist in both the source and the destination databases. We are using SQL 2008 R2 (10.50.4263).
AdamY
0

Comments

4 comments

Sort by
  • James B
    Thanks for your post, and sorry you're having some trouble.

    In theory, this particular issue should be fixed- can you update to the latest build via Help > Check for Updates?

    If the problem isn't resolved, you may be seeing a slightly different incarnation of the problem, so could you send over the source and target table definitions to us at support@red-gate.com (quoting F0074498 in the subject line) and we can get it looked at?

    Thanks!
    James B
    0
  • AdamY
    Thanks for the help. I thought I had the latest version but didn't verify before posting this question.

    I updated to 10.4.8.87 and tried again. No luck. The deploy script drops the index then creates the index, but does not add the ext. property back.

    I will send the source, target, and deploy scripts to the support email as you requested.
    AdamY
    0
  • James B
    Sorry to hear that's not working - will keep an eye out for the files, thanks.
    James B
    0
  • James B
    Thanks for the files- I can confirm I see the same. I've reopened the bug we had logged for this (ref. SC-4710)

    I can't promise an ETA on a fix unfortunately, but our dev team will take a look- hopefully it's nothing too complex!
    James B
    0

Add comment

Please sign in to leave a comment.