I'm developing a CMS for a client and we need to use SQL Server. I'm working on a Mac and tried to run SQL Server on Docker, but it's not working well. I also tried Azure and Amazon RDS as a remote solution, but the response is not so good.
I'm thinking about using MySQL in development (using migrations), when it's time to deploy it on production, I want to configure the connection to SQL Server and run the migrations. Is there a chance to succeed? Is it a bad solution?
The ideal situation would be to always use the same local environment as the production environment. This way you will hit problems early on and you don't get any surprises regarding databases.
My advice would be to put some extra hours is getting SQL server working. Laravel has some features that are better implemented for MySQL than SQL and vice versa. Every migration call should work on both systems, but if for example you need to do some special raw queries you might need to use different calls which will be a pain in the ass!
