DEV Community

Discussion on: SQL Project in VS: Why column order matters?

Collapse
 
vyavorskyi profile image
Vitalii Yavorskyi

Hello, Revavyr
"adminer.org" could work for small projects or small teams. But it becomes unreal when the team is 5+ engineers.

Collapse
 
ravavyr profile image
Ravavyr

why?
Writing CREATE queries is absolutely not necessary anymore these days.
And when you have multiple devs, you mainly need an export/import process , or a batch script that can pull from prod into their local.

No one needs to write CREATE queries like these anymore, haven't had to for years.

Thread Thread
 
vyavorskyi profile image
Vitalii Yavorskyi

Could you please describe this process? It will be interesting to see it
Thanks

Thread Thread
 
ravavyr profile image
Ravavyr

it depends on the project, there is no one size fits all solution for this.

Simple wordpress sites for example, you can easily have a bash script that a dev runs locally that connects to the dev database, exports it, imports it locally and runs a domain swap so the local urls work correctly.
Every framework/platform/system is going to be different depending on setup and structure.