Options

Smart Rename not handling Schema Moves properly

sfrigardsfrigard Posts: 5 Bronze 2
edited March 20, 2013 6:43AM in SQL Prompt Previous Versions
I am moving a large number of objects from one schema to another. I notice that when there are programmability objects involved in the refactoring, that the Alter Schema statement is called after the Alter statements for those objects. This results in errors being generated.

I am finding myself going into the script and manually moving the Alter Schema statement after the drop constraints steps and the refresh views steps.

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for inconvenience caused.

    We have logged a support call (call reference: F0070868) and would like to investigate this issue further.

    I will email you with few more questions.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.