Hot answers tagged schema
SSDT is comparable to Liquibase/Flyway as it does what they do but by taking a different approach. With SSDT you have the development environment so you get things like go to definition, find references and intelli-sense as well as the ability to compile a project into a dacpac and then deploy that dacpac to a database. The SSDT way (and redgate sql compare ...
MongoDB can efficiently store these images provided their total size does not exceed the 16MB document limit. If you are likely going to this, you should consider redesigning your schema, otherwise your schema design will be fine.
I just top-up prevision answer. The biggest difference described on Flyway web-site on central place: Solves only one problem and solves it well. Flyway migrates your database, so you don't have to worry about it anymore. Visual Studio + SSDT + SSIS = full power ETL Tool, with only one real drawback - it only work under windows It need Windows + SQL ...
Only top voted, non community-wiki answers of a minimum length are eligible