Not able to commit the filles
mayurbhot
Posts: 2
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
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
Comments
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.
Redgate Software