Red Gate forums :: View topic - Schema Difference Script Has Errors
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Schema Difference Script Has Errors

 Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
ivishnev



Joined: 15 Dec 2011
Posts: 1
PostPosted: Thu Dec 15, 2011 8:35 pm    Post subject: Schema Difference Script Has Errors Reply with quote
Hi Red Gate team,

We've been using Red Gate Comparison Tools for a while and I must say they are really good, however DBA team always had issues with schema difference scripts, specifically because of our in-house naming conventions, e.g. mask for stored procedure is <table name>$<action>

At the moment, me and the rest of DEV team are automating daily deployments including database. Hence, when differences between source and target are built, we get the following result in output SQL script, which is leading to an error.

Code:
ALTER PROCEDURE [ThreadRecipient$GetByMessageGroupId]$GetByMessageGroupId


or

Code:
ALTER PROCEDURE [TrackingAttachmentMessage$Insert]$Insert



In case if you're out of solution, I'll go ahead and write a regex, which is going to comment out later token occurrence, to resolve error (ALTER PROCEDURE [TrackingAttachmentMessage$Insert]--$Insert), but before I do, just wanted to ask Red Gate support team first.

Thanks in advance!


Kind regards,
Ivan Vishnev
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids
PostPosted: Mon Dec 19, 2011 2:39 pm    Post subject: Reply with quote
Thanks for your post. To the best of my knowledge, there isn't anything immediate that you can apply within the tool to account for this, so you'll need to go down the workaround route I'm afraid.

I've logged this though in our internal tracking system under ref CSD-158, and we'll let you know when there's any movement on it.

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
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