Smart Rename not handling Schema Moves properly

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Smart Rename not handling Schema Moves properly

Postby sfrigard » Mon Mar 18, 2013 6:24 pm

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.
sfrigard
 
Posts: 1
Joined: Mon Mar 18, 2013 6:18 pm

Postby Anu Deshpande » Wed Mar 20, 2013 11:43 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests