What a lot of others are saying: forget MAMP, get on the Vagrant train. It is a tad harder to learn, but it will be worth it in the long run. It will help you pick up some *nix command line skills, which will be useful in development if you don't already have them. You'll need some VM software to run it, I recommend VirtualBox. VirtualBox is also great for spinning up different Linux or Windows desktops.
MySQL Workbench is a great and free tool for designing schemas and then synchronizing the design with the actual database. It does a lot more than that, but that's all I use it for.
Sequel Pro is great and free, but if you are willing to throw down a little cash, I like Navicat. You can use it for more than just MySQL. I have an MSSQL database I have to administer and am able to do that with Navicat.
Homebrew is a must, as is iTerm2.
As I stated above, if you don't already have them, learn command line skills. Don't just rely on GUIs. I have worked with people who have always used GUIs and when the need arises to use the command line, they are completely helpless. Don't be that guy.
I spend 90% of my day in SSMS, but when I need to do a quick CSV file import or run something against another DBMS, I just use Navicat's tools. They're not as good as SSMS, of course, but the cross-DB option and import tools are handy to have around.
Link: http://www.navicat.com/products/navicat-premium
I love Jetbrain's PHPStorm IDE, but I don't know that I'll be drinking the cool-aid with their SQL IDE. And yeah, the fact that it's written in Java does kinda suck.
Is the theme named the same? That would be the first thing to change.
Plugins suck if you have to configure them but it should be in the DB along with the pages/posts and widgets. You need something to compare the dev to live database with....
maybe this : http://www.diffkit.org/
or look at mysql workbench since it apparently has some tools for this which are mentioned here : https://scriptingmysql.wordpress.com/2013/01/31/using-mysql-utilities-workbench-script-mysqldbcompare-to-compare-two-databases-in-replication/
Navicat has db sync , it has a 30 day trial period so it's another option :
> I've been told that there are stored procedures as well that needs migrating over
Yeah, you'll probably need to rewrite those. The syntax for data manipulation (select, delete, update, insert) is reasonably standard, but everything else is vendor-specific.
If you just need to do the data, install MySQL and give Navicat's import tool a try.
Failing that, the MS SQL Server GUI can give you a script with an INSERT query for every row. You'll probably need to monkey around with the schema definitions (again, the syntax there is pretty vendor-specific) though!
I'd personally import the Excel files to an SQL db using Navicat and then build the front end on those databases.
Afraid I don't know of any all-in-one solutions although I'm sure they exist
I would say give Navicat Premium a try. Can't speak for SQLite to MSSQL but I have used it to convert MySQL to MSSQL successfully. It is pricey but they offer a fully functional 14 day trial which should give you a couple weeks to get your conversion done even if you decide not to purchase it.
I use Navicat. It's kinda pricey but worth it imo. There are some free/open-source alternatives but I haven't tried them. I was referred straight to this. http://www.navicat.com/products/navicat-for-mysql
This how I got into development
What is your project about? Do I need to know the following languages? Are there any other languages besides the followings? What can I do with all these languages? They are allot of them around. Ruby is one just don't picking based on favorites of such-and-such person's preference it doesn't worked that way.
I didn't chose JavaScript/JQuery and PHP/MySQL I did it because I know what they can do and provide me in my project and I don't care what other people think of me. I like PHP because I am also learning C++ and to me I consider it as a must in my current project.
I've always used PHPMyAdmin for managing MySQL but my boss just turned me on to Navicat which runs on Windows, Mac, Linux and iOS. I still prefer what I am used to but it seems to be a good option.
Just incase you have never seen this tool.
http://www.navicat.com/
Worth every penny, and as far as I remember it can sync databases, may not work, but one of the best database tools I have ever seen.
It seems that you need a database design tool (aka data modeler) with the reverse engineering feature. This feature allows you to import a structure of an existing database and create a database diagram out of it. So you get a graphic model of your database with graphical representation of all tables, columns and relationships between tables. If you'd like to try how it works, you can use - for example - Vertabelo or Navicat. Both applications have a reverse engineering feature but the great advantage of Vertabelo is that you don't need to install it on your computer. It works completely online. More information about reverse engineering in Vertabelo can be found here. As for Navicat, if you'd like to get to know more about reverse engineering you'll have to download a manual from its website. I strongly recommend Vertabelo, simply because I use it for some time. It's easy to use, convenient and very intuitive with a simple graphic interface. Just try it. And if you won't like it, you can still try Navicat to compare both tools. I've never worked with Navicat, so I won't evaluate it :)
Back when I last checked, Navicat wasn't available for Mac OSX, but it appears that they've now started building versions for the platform. This is very good news.
Previously, I've been using Sequel Pro, as it's a decent enough app to get the job done, and it's free. It's starting to show its age with the newer retina/Yosemite OSX apps around it, and the UI leaves a bit to be desired for people with several disparate databases to manage, but it works!
I use navicat to create all my SQL queries. It allows you to connect to multiple databases and has a pretty good visual SQL creation tool.
The tunnel script feature allows you to directly work with your servers database.
It it pretty easy to set up but PM me if you need a hand setting it up.