3 ms·
> why use ___ instead of Postgres? MSSQL has DataDude. You write your database as CREATE statements. This is then parsed into an AST and semantic model, diffed
by zamalek 8y ago
> why use ___ instead of Postgres?
MSSQL has DataDude. You write your database as CREATE statements. This is then parsed into an AST and semantic model, diffed against a live database (or another script) and you get an ALTER script. You also get working intellisense, build errors, and everything you'd expect from something like C++. It completely changes how you develop databases into something a whole lot more modern. Especially in source control: migrations are storing history on top of the history which source control already provides, which is nonsensical.
I still want to develop something for Postgres someday that replicates this.
- garblegarble 8y agoLiquibase is quite nice for doing this in a cross-database way - you describe the changes you want to make to the schema and it applies them as needed to the db (and because you're properly describing the changes it can also do rollback for a change). We use the same migrations across hsqldb, postgresql and sql server and it just works
- weberc2 8y ago> MSSQL has DataDude. You write your database as CREATE statements. This is then parsed into an AST and semantic model, diffed against a live database (or another script) and you get an ALTER script. Oh wow, I've wanted exactly this for Postgres. Never knew how to search for it though.
- atonse 8y agoI used to use RedGate's SQL Compare (and SQL Delta) for this for years. Compare two databases and spit out an alter script to get you from one state to another (for schemas and data). The tooling is definitely lacking in the Postgres world. I like using Postico on the mac for basic data tasks, since it's rather polished. But doing anything else is a slog using an ugly app.
- jakobegger 8y agoIs the product name really DataDude, or is that a typo? Do you have a link to that product?
- zamalek 8y agoIt was the codename, it got rolled into Visual Studio and is now nameless (DB projects). https://www.c-sharpcorner.com/article/create-sql-server-database-project-with-visual-studio/ https://www.c-sharpcorner.com/article/create-sql-server-data...