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

Very well easy to use and helps productivity of user drastically

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

• Export data
• Generate scripts
• connecting to SQL instances

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

• it can still be made easier for connecting perspective
• some bugs on versions of SQL can be avoided.
• can be more user friendly

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

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.

• easy to use accessibility
• durability, It has been durable
• recovery of old tabs.

Incentivized