179 results found
-
Error when you using a table alias AS GO
I got an error when there was a stored procedure that the table had an alias as GO and it didn't let me commit any changes or get latest
3 votesIn v1.0.4, we updated our parsing and we can now handle GO as an alias in some places.
We still recommend not using GO as an alias since it is a keyword.
Please email support@red-gate.com if you experience any issues when using GO as an alias.
-
Allow me to specify where to save the Working Bases (e.g., Disk/Drive D instead of C)
The WorkingBases are saved on disk C:\Documents and Settings...”.
To save disk space on C:\, we would like the Working Bases on the disque D:\ (we have databases with more than 5000 procs). Is there a setup somewehere ?47 votesIn SQL Source Control v3.3, you can now configure the location of your working bases. Information is at https://documentation.red-gate.com/display/SOC33/The+specified+path%2C+file+name%2C+or+both+are+too+long.
-
What's the license cost going to be?
Can you let us know, in the general ballpark, what a normal user license will cost?
2 votesSQL Source Control is included in both the SQL Toolbelt and SQL Developer Bundle.
SQL Source Control is also available to purchase separately.
There are multi-user discounts available.
SQL Source Control will be licensed per user.
Please see our website for more information:
SQL Toolbelt – http://www.red-gate.com/products/sql_professional_toolbelt
SQL Developer Bundle – http://www.red-gate.com/products/sql_bundles/sql_developer_bundle.htm
SQL Source Control – http://www.red-gate.com/products/sql_source_controlIf you have any questions about your current licenses or would like a quote on the bundles mentioned above, please see our website or contact Sales@red-gate.com.
-
Commit Asynchronously
It would be helpful if the commits could be asynchronous so I can continue working on something else while it's running. I figure you've run your changelist and have the diff or data you want to post so having me sit around for a slow Inet connection to finish transmitting data when I could be running a backup or editing a stored procedure would help productivity a lot.
18 votes -
ability to add comments when commiting changes
it be very usful to add comments when commiting changes - so we can see why a certain changes were made
1 voteThere is a 1 line comment box at the top of the “Commit Changes” tab for your comment. If you have a SVN Hook set up to require comments, then your commit will fail unless a comment is entered.
-
ALTER as well as CREATE scripts
It looks like each commit adds a CREATE script. To be really useful in a continuous integration environment, we'd need ALTER scripts. Ideally each commit would generate a CREATE for the complete object, and an ALTER from the previous revision.
20 votesSQL Source Control 3.0 is now available!
It includes a new feature called ‘Migrations’ that will help avoid data loss when renaming a table as it allows you to create, store and share SQL migration scripts for accurate deployment.
For more information about Migrations, please visit:
http://www.red-gate.com/supportcenter/Content/SQL_Source_Control/help/3.0/SSC_Working_With_Migrations -
SQL Source Control won't stay docked
Upon opening SSMS, SQL Source Control always starts up as a tabbed document. I always (re-)dock it, but it doesn't remember that preference.
6 votesThis has been completed in EA6 (v0.3.3.1), which was released on May 6th. Please let us know if you experience any issues with your docking.
-
Bug - Bad object names causes error (Obj name contains #)
So, this is bad development, but someone put a proc named dbo.USPEmp#. I get all sorts of errors now because of the # sign in the when getting latest updates or trying to delete and commit.
Failed to update:
oEc.#8Jf: Errors occured whilst parsing file C:\Users\adamr\AppData\Local\Red Gate\SQL Source Control 0\WorkingBases\b3ae1b30-6f18-4d35-a002-1daa9b3501b5\Stored Procedures\dbo.uspEmp#.sql
'line 5:34: unexpected token: ["#",<735>,line=5,col=34] [char=85]'
---> #Eyg.#Lyg: Errors occured whilst parsing file C:\Users\adamr\AppData\Local\Red Gate\SQL Source Control 0\WorkingBases\b3ae1b30-6f18-4d35-a002-1daa9b3501b5\Stored Procedures\dbo.uspEmp#.sql
'line 5:34: unexpected token: ["#",<735>,line=5,col=34] [char=85]'
---> line 5:34: unexpected token: ["#",<735>,line=5,col=34] [char=85]
--- End of inner exception stack trace ---
at #oEc.#7Jf.#t.#B3.#sKf()
at #oEc.#7Jf.#gKf(Action action)
--- End of inner…1 voteThis is fixed in v1.0.
Thanks for your help!
Stephanie M. Herr
SQL Source Control – Project Manager -
Ability to create a new folder in SVN or TFS when linking a database
When linking a database for the first time, it would be nice if the path selector also had the ability to create a new folder based on the selected database name, so that I don't have to go into my source control system to create the folders.
It would really saves us a few steps if you can automatically create the folders required when linking a new DB to source control. E.g. Tortoise does it just fine in VS. For example, if I specify a path /existingfolder/newfolder when linking a DB, I expect you to create the /newfolder directory in…
26 votesThis feature now appears in SQL Source Control version 2.2!
For more information about the release, please see:
-
Support for SQL Server 2008 "data_compression" keyword
Specifically, I need support for the keyword "datacompression" before I can use this tool successfully. See SQL Compare bug ID SC-4501 for more information. Note: SQL Prompt Format also fails to parse the datacompression keyword syntax.
27 votesThis feature is now available as of v1.1.0.19. Please use Help > Check for Updates on the SQL Source Control tab within SSMS to make sure you have the latest version.
Thank you!
-
Setup tab link URL should be selectable
The link text on the setup tab should be selectable. It would be an easy change, and when you're creating a new database from the source you don't have to look up the URL somewhere else if you want to "clone" a database.
9 votesIf you right click on the URL on the Setup tab, you can copy it. I know this is kind of hidden. This works for both SVN and TFS.
-
Problem with expiration
This release of Red Gate SQL Source control...has expired. I tried to download a newer version but I am getting the same message.
Please help me out...I would like to test your product.
2 votesIf you need a trial extension, please contact sales@red-gate.com.
-
1 vote
This fix is included in SQL Source Control v2.0, http://www.red-gate.com/MessageBoard/viewtopic.php?t=12947.
-
View "Get Latest" script before execution
It would be beneficial to see the sql script that "get Latest" finally executes (with the option to execute having screen the scirpt) . I have found this very useful in other db sync tools especially if the script fails.
13 votesYou could use SQL Compare Pro and the SSMS Integration Pack to see the script.
If the script fails, then you will have the option to view the script in a query window and you can edit it as needed.
-
Allow Access to SQL Source Control from Visual Studio
I would like for SQL Source Control to also be supported in Visual Studio so my application developer co-workers who prefer this environment can also use database source control without having to switch to SSMS.
37 votesSQL Connect allows you to work in Visual Studio on db changes and integrates with SQL Source Control for users that prefer to be in SSMS. There’s a 28 day free trial at
http://www.red-gate.com/products/sql-development/sql-connect. -
Browse to a SVN Repository or TFS 2010 Server Instead of Manually Typing It In
It would be a lot easier if I could just browse to a repository (like windows explorer) instead of having to manually enter it.
21 votesThis feature now appears in SQL Source Control version 2.2!
For more information about the release, please see:
-
149 votes
This is now available in the full v2.1 release, http://www.red-gate.com/messageboard/viewtopic.php?t=13147.
NOTE: If you were using the EA, you will need to clear your LinkedDatabases.xml and TableDataConfigs.xml files and re-link your databases. These are found in
localappdata\Red Gate\SQL Source Control 2 -
Add Git support
I know that svn and TFS support are important but I really hope you add Git support. Git is really taking off and I think we will be switching over at some point so Git support is key for us.
98 votesThe new 2.0.3 Early Access build now supports source controlling your databases with Git.
To get the new Early Access release please visit the following link:
https://www.surveymk.com/s/SqlSourceControl_EapSignup
Please note that we don’t support accessing the history directly from within SSMS when using Git.
-
The URI needs to be an empty directory
While attempting to Create new link to source control in SSMS 2008 I receive the following message: "The URI needs to be an empty directory."
How can I resolve this?Please advise..
Brett1 vote -
Support for Source Gear Fortress (Vault Professional Edition)
We moved source control to a product by Source Gear called Fortress. Great Source Control. I would like Red Gate to support this.
11 votesNew EA version 2.0.3, which supports Vault and Vault Pro (5.x versions) is now available with static data and shared model support.
Please visit the following link to download it:
- Don't see your idea?