Not able to commit the filles

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Not able to commit the filles

Postby mayurbhot » Thu Jun 27, 2013 6:41 pm

Hi,

I was able to link my database and commit all the code for the first time. but after I make some changes to few stored procedures. it gives me a sql a parsing error on some other stored procedure, which I haven't even changed.

Errors occurred whilst parsing file C:\\Users\\mbhot\\AppData\\Local\\Red Gate\\SQL Source Control 3\\WorkingBases\\mu4gotwm.0ih\\Stored Procedures\\qa.GetJobDetails.sql

To resolve this issue:
1. Open the affected file.
2. Edit it to ensure the SQL is valid.
3. Commit the changes without using SQL Source Control. For example by using Tortoise SVN, or Microsoft Team Explorer.
4. In SQL Source Control, click Refresh.

Could you please help us on this. We are facing this issue on few databases and hence not able to use this red gate sql source control tool. We really need to start maintaining the versioning of the databases from now.

Thanks,
Mayur Bhot
mayurbhot
 
Posts: 1
Joined: Thu Jun 27, 2013 6:34 pm

Postby james.billings » Mon Jul 01, 2013 12:17 pm

Hi,

Could you first ensure you're on the latest version of SQL Source Control (Help > Check for Updates)?

If the problem persists then it's likely there's something in that file we don't understand. If you're able to post it here (or if it's confidential, email it to support@red-gate.com quoting F0074507 in the subject line) we can try to help out.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests