Redgate Flyway vs. SQL Server Management Studio (SSMS)

Database Migrations on Java-based solutions. It has one of the best integrations with it as a database migration tool, you can do it with the community edition (no pricing involved) and it works flawlessly with Maven and Gradle. It's not an expensive tool in order to use the next level of features and is worth the money. I would recommend reaching that edition level as the object mapping feature gets really handy. I would not recommend it for any Microsoft-based solution (.Net) as is not compatible at all based on my experience, this is a tool only worth it with Java applications.

Incentivized

The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.

Incentivized

• Manage DB migration patch scripts
• Apply DB migration patch scripts
• Test DB migration patch scripts
• Setup new DB instances, including on local env

Incentivized

• Database queries
• Database management
• Table design

Incentivized

• Updating it causes problems, there have been unnecessary changes that wasted time
• Requires knowledge & studying so it's used properly
• Lots of options that might be difficult to understand for non technical people

Incentivized

• Sorting of executed queries not available
• Quality of life improvements on folders and managment
• Some outdated tools that need revamping

Incentivized

It's very easy to install and use. Even someone very new to the software will have no trouble, plus the team reach out to help you and continue to offer you support throughout. Really simple interface, clean design, all you could really ask for in a tool that needs to do a job dependably

Incentivized

It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.

Incentivized

The problem with a cloud-based tool for migration services is the cloud dependency. You are restricted to use the tool along the Cloud provider. Flyway gives you the freedom to use it in any scenario as long as you are working with a compatible database engine. Even if you are working on-premise and you don't have plans to move to a cloud architecture. Or even for sandbox development scenarios where you are a developer playing around with some project ideas. And you don't have to pay anything as long as you need advanced features, and not less importantly, you are using an open-source tool.

Incentivized

SSMS is very efficient and aids to do multiple tabs easily

Incentivized

• I definitely think it do have positive impact to our company's database management.
• We have 4 database environments and thus it is easy when we push the database to various environments.

• SQL Server Management Studio is our go-to tool for almost everything we do with SQL Server. Highly efficient and flexible.
• Compared to other alternatives, I would say we save at least 25% of the overall time we need to spend working in SQL Server.

Incentivized