I want to create a mysqldump file from a SQL Server database, I know its possible using MYSQL workBench, what i want is to make it completely automate. So the script runs on a daily or weekly basis and create a copy of MSSQL database and update mysql database with the copy. Is there any tool or script which can do that task.
Take the 2-minute tour
×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
migrated from stackoverflow.com Jul 10 '13 at 16:19This question came from our site for professional and enthusiast programmers. |
|||||
|
|||||
|
There is no built in solution that allows to create the equivalent of a MySQL dump file from a SQL Server database. (Instead SQL Server employs a backup solution that actually works and provides transactionally consistent backups, but that is only a side-note...) You can use power-shell to write you own solution, but that is not going to be straight forward either. As a starting point you can look here: http://blogs.technet.com/b/heyscriptingguy/archive/2010/11/04/use-powershell-to-script-sql-database-objects.aspx After you scripted the objects, you can use scripter.Options.ScriptData to generate the data. However, instead of reinventing the wheel you might want to look at third party replication solutions. While I have not used it myself, http://www.symmetricds.org/ looks very promising for that purpose. It supports 12 database platforms including MySQL and SQL Server and offers automatic synchronization of databases with one or more subscribers. It comes in two versions, an open source version with GNU license and a fully supported "pro" version. |
|||
|
|
