Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: What is a good, straightforward Perl with Mysql development environment?

by Corion (Patriarch)
on Aug 05, 2019 at 18:07 UTC ( [id://11103976]=note: print w/replies, xml ) Need Help??


in reply to What is a good, straightforward Perl with Mysql development environment?

How do I keep the development MySQL schema in synch with the live one?

This for me sounds that you need to establish a ground source of truth, not only for changes to the DB schema but for all the other things too. Ideally you can build up a new environment from all the ground sources of truth and it will match the current state of the production environment.

For an SQL schema, I would propose that all modifications to the schema go through SQL text files which are kept under source control and applied one by one. For example App::sqitch purports to do that, but you can also do it manually or with a script of your own.

If you can keep to moving all changes to your production environment through text files source control, you can basically replay and replicate the environment everywhere where you can replicate your source control to.

  • Comment on Re: What is a good, straightforward Perl with Mysql development environment?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11103976]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2024-04-24 10:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found