what is the best practice when creating a database schema for the first time? Do I need to write schema migrations, or create it from the DBMS tools?
1
-
1Sharing your research helps everyone. Tell us what you've tried and why it didn't meet your needs. This demonstrates that you've taken the time to try to help yourself, it saves us from reiterating obvious answers, and most of all it helps you get a more specific and relevant answer. Also see How to Askgnat– gnat2021-08-25 08:21:33 +00:00Commented Aug 25, 2021 at 8:21
Add a comment
|
1 Answer
Of course this depends a bit on your actual needs, but in general, automated and reproducible processes should be preferred over manual processes.
If you do a manual install, you will want to document it accurately so a coworker (or your future self) is able to execute it exactly, but then you might as well put that effort into an automated setup using your database framework's migration mechanism.
-
" reproducible processes should be preferred over manual processes." I liked that one. For the first time can't someone use the dump file of the database ? I mean that even if you have a dump file or a sequence of migration commands imbedded in a script, it will still make the process of installation automatic. So why use migration over just a simple dump file?themhz– themhz2021-08-25 08:45:49 +00:00Commented Aug 25, 2021 at 8:45
-
1Using a dump file is indeed also a reproducible way of initializing the database, but depending on the dump file format (binary?) it might not mix well with source code version control. It also introduces a difference between the initial schema definition and later schema definition updates, with may not be a real problem but has a slight smell :-)Hans-Martin Mosner– Hans-Martin Mosner2021-08-25 09:29:23 +00:00Commented Aug 25, 2021 at 9:29