Recently, a vendor announced that they were upgrading their processes, and an automated, daily data dump we are getting from them will now come in a MySQL datadump format. Unfortunately, we're a Microsoft-only shop, so we can't import those files directly.
So my question is: How can I take the data dump file and import it into a SQL Server 2005 instance to create a database?
Things to note:
- The solution needs to be automated and require no manual intervention; it has to be something we can schedule daily and just get notification that it worked / failed.
- We'd love tools that are free (who doesn't?) / already purchased (e.g., already a part of SQL Server), but we're okay with buying something if needed.
- We have no control over the data or the original database, so we don't have control over running the
mysqldumpcommand again with the 'compatible' option set differently.
- We really, really don't want to do something like load up a local instance of MySQL to import the dump and then pump the data over to MSSQL. Like I mentioned, we're an MS-only shop, and we're not set up to support a MySQL instance, even for an automated process like this.