![]() ![]() ![]() Only that care needs to be taken that the two are as similar to each other as possible to minimize the occurrence of unexpected problems. Much better to foobar development than production and needing to put out fires after the fact. ![]() Don’t get me wrong, I believe that having development and production separate is a very good thing. IMHO, just having different development and production instances can introduce discrepancies that can cause problems. What seems to being not considered is the cost of developer time. I get the incentive, to save on the cost of the database. The fact that the question is being asked is enough reason to give pause. But that describes 2-3% of the use-cases out their in the business world.Īre they similar enough that I don’t have to worry about it? Database like Oracle will help you when you have a robust codebase and database design and you push the envelope on what Oaracle can do that something like MySQL can’t. a Lamborghini)?Īlso, I would like to add that I would rather run a medium-to-large business on a ell architected MySQL or PostgreSQL solution than a pile of garbage using Oracle. MySQL grew up a lot since the early 2000s, but there is a reason large corporations use Oracle!īut since you likely aren’t WalMart or Citibank or Amazon, does your company really need Oracle (i.e. If saving money is the goal, I would look into PostgreSQL because I think it has a much more enterprise-based solution, is open-source, and can probably compete head-to-head with Oracle in most areas. If you are like most people, a Toyota Camry or a Honda Accord would do. The question, however, is do you want/need either? ![]() The difference between a Lamborghini and a Hyundai… NET rest layer around the database that relied heavily on SPs. Some people will probably try to tell you it will be really easy but unless you are using an ORM of some kind like Doctrine or a platform that facilities switching between databases like some CMSs it probably won’t be that simple.A few backs I was part of a project which they went from MySQL to SQLServer and that took about a year to complete but included factoring out all the inline SQL in php into rest service calls and building a. Not to mention installing the oracle dependencies for PHP can be a very painful experience both in your production environment and locally.My recommendation would be to not allow anyone to underestimate or undermine the effort it is going to take to complete a migration like this properly. Unless your existing application is programmed in such a way to facilitate the migration it is likely to be a large effort depending on the size of the projects or number of them that need to be migrated. I’ve never been part of nor heard of a database migration that has went smoothly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |