MySQL Workbench - Database Migration: Microsoft SQL Server to MySQL

[Edwin Desouza]

MySQL Workbench: Database Migration
- Download: http://dev.mysql.com/downloads/workbench/
- Docs: http://dev.mysql.com/doc/workbench/en/wb-migration.html
- Migration from Microsoft SQL Server (versions: 2000, 2005, 2008, 2012)

Microsoft SQL Server migration:
http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/
http://mysqlworkbench.org/2013/08/video-tutorial-setup-a-restricted-sql-server-account-for-migrations-with-mysql-workbench/

https://www.percona.com/blog/2016/06/23/migrate-from-ms-sql-server-to-mysql/
http://www.martin-brennan.com/could-not-successfully-convert-ucs-2-string-to-utf-8/

http://websitenotebook.blogspot.com/2013/12/sql-server-to-mysql-syntax-differences.html
http://websitenotebook.blogspot.com/2013/11/converting-sql-server-strored.html

https://lalitvc.wordpress.com/2016/12/28/mssql-to-mysql-data-migration-using-mysql-workbench-6-3/

http://blog.mclaughlinsoftware.com/2012/09/16/bulk-transfer-still-fails/
http://blog.mclaughlinsoftware.com/2012/09/13/trying-to-migrating-data/
http://blog.mclaughlinsoftware.com/2012/09/16/setup-sql-server-schema/
http://blog.mclaughlinsoftware.com/2012/09/11/sql-server-2012-install/
http://blog.mclaughlinsoftware.com/2012/09/12/sql-server-odbc-osn/


MySQL Data Transfer using SQL Server Integration Services (SSIS)
http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis


MySQL Linked Server on SQL Server
http://www.packtpub.com/article/mysql-linked-server-on-sql-server-2008
http://dbperf.wordpress.com/2010/07/22/link-mysql-to-ms-sql-server2008/
http://forums.mysql.com/read.php?60,124480,124480#msg-124480
http://developer.infi.nl/index.php?ID=6&article=6


http://www.sqlservercurry.com/2012/04/set-and-select-sql-server-vs-mysql.html
http://www.sqlservercurry.com/2012/04/temporary-tables-sql-server-vs-mysql.html
http://www.sqlservercurry.com/2012/04/dense-rank-mysql-vs-sql-server.html
http://www.sqlservercurry.com/2012/03/reset-row-number-for-each-group-sql.html
http://www.sqlservercurry.com/2012/03/generate-row-number-sql-server-vs-mysql.html



Edited 14 time(s). Last edit at 12/28/2016 03:37AM by Edwin Desouza.