Comments
Sort by recent activity
The product should work with that configuration. Since we make frequent connections to SVN you will have to use a tool such as Pageant to keep the key available for SQL Source Control.
If you run pageant ( available from the putty page here http://www.chiark.greenend.org.uk/~sgta ... nload.html ), then right click on its system tray icon and "Add Key" then the product should be able to authenticate with your subversion server as normal. / comments
The product should work with that configuration. Since we make frequent connections to SVN you will have to use a tool such as Pageant to keep the key available for SQL Source Control.
If you run ...
Thanks for reporting the problem. I've managed to reproduce it locally, and raised an issue (SOC-1261). There's a problem with our reading in the collation from the script file. It gets written to source control correctly, but read back wrong. I'll have a look at a fix and try and get it into the next private build. / comments
Thanks for reporting the problem. I've managed to reproduce it locally, and raised an issue (SOC-1261). There's a problem with our reading in the collation from the script file. It gets written ...
Hi,
Thanks for reporting the issue. The error indicates that there are two files under the directory the database is linked to which contain "Create table [dbo].[XXXXXXX]". One case this can happen is where you link to SomeFolder, and then copy it into itself, so you end up with
SomeFolder
SomeFolder\Tables
SomeFolder\Tables\dbo.XXXXXX.sql
SomeFolder\OldVersion
SomeFolder\OldVersion\Tables
SomeFolder\OldVersion\Tables\dbo.XXXXXX.sql
Is it likely you have two copies of the create table file in source control? If so, can you see why? If you could email me a zip of the folder from source control ( to my username @red-gate.com) I should be able to see more of what's going on. / comments
Hi,
Thanks for reporting the issue. The error indicates that there are two files under the directory the database is linked to which contain "Create table [dbo].[XXXXXXX]". One case this can happ...
luan_au,
Sorry for the delay in replying. Thanks for submitting the problem you had, both here and from within the product.
The problem you have seen occurs when the working copy of the database contains a statement such as
EXEC sp_addrolemember N'role_name', N'SunBrowser'
GO
But not the corresponding
CREATE USER SunBrowser
statement.
We are working on a fix for this issue (SOC-845). You should be able to carry on working if you SVN update (using tortoise, or any other SVN client) the Security\Users and Security\Schemas folders in your working base in order to make sure that the create user statement exists. I will PM you with the precise details for your case. / comments
luan_au,
Sorry for the delay in replying. Thanks for submitting the problem you had, both here and from within the product.
The problem you have seen occurs when the working copy of the database ...
You can search UserVoice by typing in the 'Suggest a new feature or enhancement'. It searches as you type, in order to try and reduce the number of duplicate entries. I agree it's not the most obvious behaviour! / comments
You can search UserVoice by typing in the 'Suggest a new feature or enhancement'. It searches as you type, in order to try and reduce the number of duplicate entries. I agree it's not the most o...
Hi,
I've just had a quick look at the work around for this.
You should be able to get back up and running again if you:
- Unlink the database from source control
- Make sure the DB is in same state as source control (sounds like this should be true already)
Then in source control explorer:
- Delete RedGate.ssc
- Check in
- ReCreate RedGate.ssc (don't undo the delete)
- Check in
Now link to source control. if you go to the tabs you should see a long spinny and be good to go.
Let me know if that works for you.
We're still looking at fixing the underlying bug so this faff isn't required, but we'd really like you to keep trying the product. / comments
Hi,
I've just had a quick look at the work around for this.
You should be able to get back up and running again if you:
- Unlink the database from source control
- Make sure the DB is in same state...
Hi Ramesh,
For the original error, it would be handy if you could send me ( simon dot jackson at red-gate dot com ) your logs from %LOCALAPPDATA%\Red Gate\Logs\SQL Source Control 0 so i can have a dig round for what the original error was.
The functionality you need to recover (Telling source control the your object is the way you wish to resolve the conflict) is not implemented yet, but you should in theory be able to fake it out by hand so you can continue working.
One option would be to use TortoiseSVN (or you svn client of choice) to check out the whole scripts folder, then use SQL Compare to sync the live database to that folder and commit the changes manually (again using TortoiseSVN). You are aiming to make sure that the version in source control is the same as your live database ( so that the conflicts go away ).
If that's not possible than I have a few other options in mind.
you may also find that you need to unlink and re-link to the same place once you've done this, since there is a known issue with our recovery from SVN errors (SOC-138). / comments
Hi Ramesh,
For the original error, it would be handy if you could send me ( simon dot jackson at red-gate dot com ) your logs from %LOCALAPPDATA%\Red Gate\Logs\SQL Source Control 0 so i can have a ...
Hmm, looks like the server has run out of memory. I've got a few questions to help me spot the problem:
- Is the error repeatable (does it happen if you try the same thing again)
- Is the server likely to be doing other things at the same time?
- Is the server heavily loaded/shared
- Sql server should have generated an error in the mssql\log\ (living somewhere like C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Log ) which would be useful.
- It would also be helpful if you could run 'dbcc memorystatus' a few times whilst waiting for the commit tab to load, and send the results.
- Can you send me a SQL Compare snapshot of the database.
(My email address is simon dot jackson at red-gate dot com ) / comments
Hmm, looks like the server has run out of memory. I've got a few questions to help me spot the problem:
- Is the error repeatable (does it happen if you try the same thing again)
- Is the server li...
Oops. Is there any more information in the message? You might be able to CTRL + C the dialog, or screen shot it if not.
My email adress is my username at red-gate.com / comments
Oops. Is there any more information in the message? You might be able to CTRL + C the dialog, or screen shot it if not.
My email adress is my username at red-gate.com
Hey rich, have you had a chance to get any more info yet?
Thanks / comments
Hey rich, have you had a chance to get any more info yet?
Thanks