Schema Difference Script Has Errors

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Schema Difference Script Has Errors

Postby ivishnev » Thu Dec 15, 2011 8:35 pm

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: Select all
ALTER PROCEDURE [ThreadRecipient$GetByMessageGroupId]$GetByMessageGroupId


or

Code: Select all
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
ivishnev
 
Posts: 1
Joined: Thu Dec 15, 2011 3:17 am

Postby peter.peart » Mon Dec 19, 2011 2:39 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests