A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company running the db decided that they don’t want to keep a lower level consumer type tier. Since their minimum plan is now $20/month, I decided to look elsewhere. My first move was to try Azure Database for MySQL. This is a quick look at moving the MySQL data.
I have MySQL Workbench, so I started that up. I saw a note that this contained a migration wizard. I first created a MySQL database in Azure, which is really simple. Then I created two connections from MySQL Workbench. One to the existing database and one to my new one.
The next step was to start the Migration Wizard. This is under the Database menu.
As with all wizards, this opens with a welcome page. I clicked Start Migration to get going.
The wizard is fairly simple. Once I had this working, I walked through the wizard, choosing my source and destination. This was a simple process and things connected up once I’d opened the firewall.
After verifying connections, I selected everything. Since this is a WordPress site, it’s a fairly small schema and set of objects.
I basically clicked next, next, and let everything transfer. This only took about 5 minutes.
Once this was done, I queried the database, and everything was working. I saw my data and it appeared complete. No errors, so I assumed things were correct. Row counts seemed to verify this.
This was pretty simple, perhaps even easier than using SSIS and the Copy Database Task since this was built in.
Now to figure out how to re-point the application.