Error trying to apply updates to Trigger from TFS to DB

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Error trying to apply updates to Trigger from TFS to DB

Postby ajkauffman » Mon Apr 26, 2010 8:27 pm

I was testing the capabilities of synchronizing Table changes, specifically a Trigger. I made a change outside of SSMS to the table's script file that contained the trigger being changed and then checked it into TFS. In SSMS it saw the change and after I attempted to apply it to my local DB, it generated an error at the \"Registering Selected Changes\" step. I don't have the exact syntax because it did not allow me to copy it, but it was something close to this:

Errors occured whilst parsing file \"C:\\Red Gate\\SQL Source Control 0\\workingBases\\dfjkdsfjklsdljksdfjlkdsf\\Tables\\dbo.Customer.sql
'Line 447:1 expecting \"conversation\", found 'GO

Not sure what is meant by \"conversation\". The same script parses just fine in SSMS.
ajkauffman
 
Posts: 4
Joined: Mon Apr 26, 2010 8:19 pm

Postby Chris Auckland » Tue Apr 27, 2010 7:35 pm

Thanks for your post.

Could you make sure you're on the latest version of SQL Source Control? (Help > Check for updates)

Can you also send the file 'C:\\Red Gate\\SQL Source Control 0\\workingBases\\dfjkdsfjklsdljksdfjlkdsf\\Tables\\dbo.Customer.sql' to SQLSourceControlSupport@red-gate.com? We should then be able to recreate the problem here and hopefully provide a fix.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby ajkauffman » Wed May 05, 2010 7:05 pm

I verified that I am using the latest version and I emailed the file you requested. Thanks for the response.
ajkauffman
 
Posts: 4
Joined: Mon Apr 26, 2010 8:19 pm

Error trying to apply updates to Trigger from TFS to DB

Postby sherr » Fri May 14, 2010 10:47 am

Thank you for emailing the files. We are looking into this now. Our internal reference number is SOC-1020.
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests