ApexSQL by Quest vs. Redgate Flyway

As soon as I start developing a new query or script, I just need to type my keywords and then all the basic for my work is already there. Just need to worry for the pesonalization. Also, I can have a template for very different scenarios, also the code suggestions, makes my code review and any error debug easier

Incentivized

If your application is running on many environments then some kind of automation for database migrations should be implemented. This will save time and trouble for employees and helps to manage migrations. However it must be understood that it is not a magical tool & should be studied properly so that it's limitations are understood & it will be used properly. Otherwise it might cause problems to the application.

Incentivized

• Disaster Recovery of database
• Management of Agent Jobs in Sql sever
• Backup and restoration of databases

Incentivized

• Easy to manage Release Management.
• Version Control for Databases.
• Saved DevOps time.

Incentivized

• Need to improve on optimization sometimes it take too much time during data loading and unloading
• The IDE comes in web browser.It should develop its own IDE to write code
• I don't particularly appreciate that there is no way to get all data for any records

Incentivized

• The Object Mapping should be available on commuinity edition
• More Programming Languages support

Incentivized

It's free to use and it has a lot of unique features like tab navigation, Coloring of tabs, Execution alerts, helps in automatically writing query and the best what I liked in ApexSQL is fast database creating,tables auto fill.i recommend giving the tools a try as i think you will find them very useful

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

• Reduced the time needed to maintain and audit our MS SQL databases
• Automation reduced the time and effort needed to execute on daily tasks
• Increased efficiency overall by making data comparisons and other day to day tasks more efficient

Incentivized

• DB migration is fully automated
• DB migration is committed to source code, repeatable on all environments
• DB migration is fully integrated into development cycle

Incentivized