SQL Connect (for Visual Studio)
Thank you for trying SQL Connect. Your feedback will influence what we do next!
-
Simple
I want simple:
1. I like the Solution Explorer - Keep that
2. I would like to double click an item have it open, start typing and have it do an auto checkout
3. When I was done and checked it back in, I would like THAT script to be synchronized back to the serverThis would be simple easy and faster than the synchronize method now. This product may buy me the history (source control), but it will cost me production. Not worth the tradeoff.
A long time ago I used a simple product called SQL IDE Xpress -…
3 votes -
script as alter for views
For functions there is a right click button that says scripts as alter.
For views we don't have that button.
I Prefere to have the button there as well.7 votes -
bug in sql connect for visual studio
I am currently evaluting your product to decide whether it should be purchased. After startup SQL Connect for Visual Studio is crashing when I try to preview its window. Apparently there is some kind of problem with how xaml is being parsed. Here's the stack trace:
______________________________________________________An exception was encountered while constructing the content of this frame. This information is also logged by running the application with the /log parameter on the command line, which stores results in "C:\Users\osneed\AppData\Roaming\Microsoft\VisualStudio\10.0\ActivityLog.xml".
Exception details:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Windows.Markup.XamlParseException: Set property 'System.Windows.Controls.ContentControl.Content' threw an…5 votes -
Can't CTRL-F6 to Next Window when editing a Stored Procedure
Hi
Just noticed that for some reason I can't use CTRL-F6 to go to the next Window when editing a Stored Procedure via the SQL Connect windows in VS2010.If I'm editing a table, that works fine, but editing an SP or using the "Script As Alter..." windows seems to block CTRL-F6.
A minor issue, but thought I'd point it out
Richard
4 votes -
trace file gets huge and hogs perfomance
Hi,
the latest SQLConnect version (1.1.1.111) creates a huge log file while running visual studio for a longer time. Each start creates around 1MB and it shortly gets to 50 MB and creates a new log file (log file available).
I can't seem to disable the trace just to disable the SQLConnect extension, which is not what I want.Kind regards
Joscha1 vote -
User filter in SQL Source Control that excludes users and roles from my checked in code
SQL Connect is not aware of the filter settings and exclusions I have defined in Sql Source Control. Namely, I do no want extraneous users and roles from getting checked into my source control system yet every time I perform a sync, SQL connect brings that information over.
18 votes -
Invalid object name synchronization
I moved my views into a new schema, and renamed them to something more appropriate for the project. However now every so often I get an error message when trying to sync, Invalid object name 'old view name which has been renamed and can no longer be found with a VS search', Synchronization failed Edit Synchronization SQL...
If I then try and execute the synchronization sql I get an error in sp_refreshsqlmodule_internal again stating the old no longer current view name was the error. But again a visual studio search brings up no ref to the old view.
1 vote -
High disk usage
Hi,
I am trialing SQL Connect at the moment on Windows 8 using Visual Studio 2012 and SQL Management studio 2012 with SQL Server 2012 installed locally.
When I use SQL Connect on my local database from within my solution in Visual Studio, it causes excessive disk usage 100% of the time. I am getting ~14Mb/s disk usage caused by SQL Server process when any solution is open with a SQL Connect project in there.
Hope this helps.
1 vote -
Synchronization stops working after moving SQL Connect project to any folder other than root
Each SQL Connect project is created at the root level of a project. If you move that project into a different logical solution folder, the synchronization stops working.
9 votes -
Cannot uninstall SQL Connect
Cannot uninstall SQL Connect from Control Panel. Fails with "you do not have sufficient access to uninstall SQL Connect"
1 vote -
Is there anyway to make the Sync and Get Latest run faster?
After adding a SQLConnect project to my solution, GetLatest operations within the VS2010 IDE now take at least five minutes whereas prior to adding this project it took all of 10 seconds.
After making one change to a single stored procedure, the synchronization process takes way too long.
2 votes -
Better integration in VS 2010 and SQL Compare
When you right click on the project, it's possible to open it in SQL Compare. This is a great feature, as I love SQL Compare and it gives me full control on how to compare my project and database. But it only comes up with Red-Gate's default settings. I would love to have a feature that allows me to connect a SQL Compare project file to my SQL Connect project. I can then make all the compare settings for a specific project, save it, and join it to the SQL Connect project. Of course I can fire up the SQL…
1 vote -
Create folders in the SQL Connect Project
I've been using SQL Compare and Data compare for years, and was planning to use the new SQL Server 2012/VS2010 Data Tools instead. But those MS tools are far from the quality of Red-Gate.
I've installed SQL Connect and I like the core concept. BUT I have hundreds of stored procedures which I have categorised in folders in a VS 2010 Database project. Great for better overview and control for my developers. Doing the same in SQL Connect is as I understand not possible. Is this something you consider as new functionality in SQL Connect? For now this is actually…
6 votes -
sqlconnect views
In SqlConnect a key feature is that it preserves comments including those that are _on_ the argument lines of stored procudure.
However for Views all the formatting and comments are stripped. By default I would except the SQL to appear formatted as entered (tabs/comments). For some cases this can be more valuable than the graphical representation.
1 vote -
Field properties
It would be really useful if we could see the structure of the table including column types and sizes (pref with columns sorted alphabetically) in a window without opening the alter database dialog.
3 votes -
What is the point of the data folder?
There's a "Data" folder that has nothing in it. I assume it's to add default data to tables, yet I can't seem to add anything to it.
4 votes -
Solution Explorer scrolls to top each time I open a Database Object
Each time I double-click a Stored Procedure or Table in the Database Project, solution explorer scrolls back to the top.
Just an annoyance more than anything - should stay on the opened object same as any other project file.
1 voteWe think we’ve fixed this now, please do download the latest version and let us know. You can update from within the Visual Studio Extension manager or from our page on the gallery:
http://visualstudiogallery.msdn.microsoft.com/56f7c8e8-7532-41de-b75b-00282cbc6707(Note – we haven’t yet shipped to the installer on red-gate.com)
-
Importing more than one SQL Source Control database into a solution
Is it possible to import more than one SQL Source Control database into a single solution? As soon as one has been imported, the SQL Connect window switches to 'Sync' mode and you can't access the import option.
2 votesSorry for the inconvenience here. For now we only have a workaround for this.
Please right click on the first imported Project and “Unload Project”. The option to import another project should reappear. Once completed with the second import you can right click and “Reload Project” for the initially imported Project.
Please do advise on whether this works for you and also give us an idea about how you’d like or expect it to work properly. Thanks!
-
Red Gate Support and Upgrades Messages has stopped working.
After my latest install I get the following message everytime start VS2010 or Microsoft Sql Server Management Studio
"Red Gate Support and Upgrades Messages has stopped working."Problem Details:
Description:
Stopped workingProblem signature:
Problem Event Name: APPCRASH
Application Name: RedGate.IPNService.exe
Application Version: 1.0.0.262
Application Timestamp: 4f295c0d
Fault Module Name: mscorwks.dll
Fault Module Version: 2.0.50727.5448
Fault Module Timestamp: 4e153960
Exception Code: c0000005
Exception Offset: 0000000000151749
OS Version: 6.1.7601.2.1.0.1296.17
Locale ID: 1033Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt1 vote -
Installation problem
I installed SQLDeveloper bundle using an admin account. I checked the "install for all users" option. Under admin account, SQL Connect shows up in VS2010. But I have to use another axccount for "real-life" tasks, and there SQL Connect dows not show up. Seems it asn't installed correctly in VS2010.
6 votesWe hope to fix this in a future release of SQL Connect, you can install SQL Connect from the Visual Studio gallery by visting http://visualstudiogallery.msdn.microsoft.com/56f7c8e8-7532-41de-b75b-00282cbc6707
Thanks,
Kevin Boyle
- Don't see your idea?