Red Gate forums :: View topic - Bug: Deploy script does not include extended properites
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Bug: Deploy script does not include extended properites

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AdamY



Joined: 15 Oct 2010
Posts: 37

PostPosted: Wed Jun 26, 2013 8:45 pm    Post subject: Bug: Deploy script does not include extended properites Reply with quote

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).


Last edited by AdamY on Mon Jul 01, 2013 6:16 pm; edited 1 time in total
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Jul 01, 2013 4:32 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
AdamY



Joined: 15 Oct 2010
Posts: 37

PostPosted: Mon Jul 01, 2013 5:58 pm    Post subject: Still broken Reply with quote

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.


Last edited by AdamY on Mon Jul 01, 2013 6:13 pm; edited 1 time in total
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Jul 01, 2013 6:07 pm    Post subject: Reply with quote

Sorry to hear that's not working - will keep an eye out for the files, thanks.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Mon Jul 01, 2013 7:30 pm    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group