Microsoft Visual Studio Code vs. Redgate SQL Toolbelt Essentials

If your Source Control Software is Team Foundation Server then skip Visual Studio Code. If you're using GitHub and are creating small projects Visual Studio Code is the way to go. If you need to create a large, enterprise-level application, Visual Studio Code makes it easier to set up interactions between related projects (client & server). If you're interested in getting back to the old way of using the command line to create projects and you know what to enter in the console window then Visual Studio Code is great. Visual Studio Code is a better choice if you don't know the console commands and prefer to make selections from a menu.

Incentivized

We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release. On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.

Incentivized

• Robust plugin architecture replete with fantastic add-ons that make developer life delightful.
• Integrated Terminal window allows you to stay in one application to perform most required tasks.
• Customization options are robust. It is easy to modify VS Code to your own specifications.
• It's free! Hard to believe such a well made, well maintained, robust software is a free download.
• Command+P/Command+Shift+P key commands will improve your workflow dramatically.

Incentivized

• Simple and easy comparison of database schemas and data. Differences can be copied or synced from one database to another with a click of a button.
• You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
• It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.

Incentivized

• Unlike for most languages I have used, Ruby and Rails support available for Code users isn't great. The most popular Ruby extension is unofficial, and leaves much to desire. As an example, code navigation even with language server Solargraph installed isn't as good as IntelliJ's RubyMine.
• Even there is quite good support for a language or a framework, it is almost never as good as a dedicated IDE for it. In terms of the sheer number of features available, IntelliJ IDEs handily beat Code.
• Microsoft has close-sourced some of the extensions it develops for Code itself, e.g. Pylance for Python, and that has not been perceived as a good move for open-source.

Incentivized

• Pricing.... I wish there was an inexpensive developer version I could buy for myself.
• Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
• Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.

Incentivized

Solid tool that provides everything you need to develop most types of applications. The only reason not a 10 is that if you are doing large distributed teams on Enterprise level, Professional does provide more tools to support that and would be worth the cost.

Incentivized

Looking at our current implementation, Microsoft Visual Studio Code is perfect for writing code and performing debug operations. Integration with SVN repository is easy and changes can be tracked effectively. Microsoft Visual Studio Code supports developers to write code productively using syntax check and easy customization. Microsoft Visual Studio Code also provides support for IntelliSense which prompts suggestions for code completion. It is easy to step through code using interactive debugger to inspect the root cause of error quickly.

Incentivized

It's a good tool to have, but becomes expensive to buy a user license for each developer.

Incentivized

Active development means filing a bug on the GitHub repo typically gets you a response within 4 days. There are plugins for almost everything you need, whether it be linting, Vim emulation, even language servers (which I use to code in Scala). There is well-maintained official documentation. The only thing missing is forums. The closest thing is GitHub issues, which typically has the answers but is hard to sift through -- there are currently 78k issues.

Incentivized

They have a great community website where you can search for answers but are also very responsive when it comes to direct support.

Incentivized

All the previously listed are incredible development environments that perfectly fulfill this function, but [Microsoft] Visual Studio Code goes one step ahead by providing flexibility, customization and adaptability to development environments with its own methodology, for all this productivity. of the work team is greatly increased helping to achieve the objectives set in the organization.

Incentivized

I've used Visual Studio Database Projects for this type of work in the past with some success, but Redgate SQL Compare is faster, more transparent, and simply easier to use. Faster is self explanatory. More transparent, means that it's much easier to set up your desired options for schema change deployment scripts. Easier to use, It's really dead simple. Start a project, connect your source, connect destination, click compare.

Incentivized

• Saves money by replacing suites of tools such as Visual Studio, IntelliJ, etc.
• Speeds development time and developer environment setup time
• Strengthens code quality with integrated autoformatting and linting
• Strengths Git practices by keeping version control tightly connected with the code

Incentivized

• Makes deployment fairly simple. Cutting our deployment time down.
• With the SDK, we can customize our deployment process very quickly and easily.
• History is not great, it does create scripts you can go back and see but it would be nice to have a quicker version view by object to save time.

Incentivized