07 How to Migrate SQL Server database to MySQL

[@jogioktavianus6992]

Thank you sir, Cause of this video i solve my problem's from company. Big thanks

[@learnssis]

Glad to know Jogi that it helped you.

[@pratikpandit-c1r]

Hi, Sir @Learn SSIS. I am getting the below error while migrating from MS SQL to MY SQL. Please provide a solution for the below query. Determine the number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 1 Failed

[@greatcars2133]

This is just perfect! Well detailed explanation. Much appreciated!

[@learnssis]

Thank you so much Great Cars.

[@anaranjo025]

During Source Selection, I input my username and password credentials, but by the time I get to Schemas Selection, all tables are empty. When I leave sa as the username in Source Selection, I am asked for a password, but I don't know what password to put. Anyone have any idea what I need to do here to be able to see the tables during Schemas Selection?

[@swapnilvmestry]

Superb Do we have any options to connect from ms sql to my sql and read data from particular table ? Both the databases are on the different network servers.

[@learnssis]

I don't know if can connect from one server to another one using SQL Server to MySQL if they are on different networks. If they are on the same network then I think we can create a linked server and then can connect from SQL Server to MySQL.

[@broncasrafa]

Sir, thank you so much, worked perfectly!!! Gained a follower

[@learnssis]

Thank you Sir.

[@enescivelek3369]

How can we implement this process for phpmyadmin? I wrote different methods and even my own algorithm, but I have a problem with Turkish characters and cannot fully transfer my data.

[@learnssis]

Hi Enes, unfortunately I don't have much experience with data migration using phpmyadmin. Majority of the time I have worked migrating the data using SSIS.

[@MrMneneZhalko]

What if I use localdb instead of Microsoft SQL Server and I get an error SQL Server: 17?

[@learnssis]

I have not used this method extensively for migration. Thus not sure about this error message. I usually use SSIS to migrate the data from SQL Server to MySQL or vice versa. Sorry for that.

[@lahiru776]

Thank you for your great tutorial. I followed all the steps but my Schema Selection always returning empty. Do you know how to solve this?

[@learnssis]

Hi Lahiru, I have not migrated a lot of databases from SQL Server to MySQL. I migrated just couple of them. Thus really not sure what issue might be here. Sorry for that.

[@MrRvalentin]

Thank you. Well explained and good teacher. Good karma to you !

[@learnssis]

Thank you.

[@blipur]

How about migrate database, if have million data in production, and database already use by system every time. Because live.

[@learnssis]

I would suggest using SSIS to migrate the data in that scenario. kzbin.info/www/bejne/n4SwZaeKpcmMnLs

[@akshanshsahu5386]

Hello Sir I have a 40 GB database of SQL server I want to restore the database in MySQL I am able to restore the database but the views are not restored and large size database is also not restored getting error of exceed limit so how i can do the full database resorted please help me out

[@learnssis]

Hi, you know both SQL Server and MySQL are different database management systems and backup from one system and restore to another system is not 100% accurate and compatible. For the things those are not migrated automatically, you would need to do them manually because some data types are not exactly same in sql server and mysql they are different, even the syntax of sql is different in both the systems. I think there are some paid softwares those says that they can do the migration but I have not used them thus not sure about them. If the data is not migrated then you can use SSIS to move the data for specific tables. I normally don't do database backup from sql server to mysql thus I don't have much knowledge on it.

[@vardhan1856]

Hi, Thanks for sharing this. When I am migrating from SQL server db which contains) to MySQL got migrated not and in migration summary it is showed like all objects migrated but i didn't get when i did check in mysql, how to get all those objects which are in SQL server db. Please let me know some automatic process instead of manual effort. Thanks in advance

[@learnssis]

SQL server and MySQL both use different languages and even some data types in both of them are different. The free method to migrate the database I already showed in this video which should migrate tables but if there are some stored procedures or functions in sql server those might not be converted automatically because there is some syntax difference as well in both the systems. There are many companies those have tools those does the migration using their tool but they charge for it. If you need the free solution then you can use this method and for migrating the stored procedure and other functions you might need to find some tool which can convert them from sql server language to Mysql server. I don't have much experience with the migration.

[@Dante_Kasu]

Worked like a charm, cheers.

[@learnssis]

Wow good to know that Dante.

[@melaniemurday3138]

does it update both tables in real time? For example, if i add a row in a table in MySQL, will it appear in SQL Server? Please i need a reply

[@learnssis]

It is a one side migration. The row that you will add to MySQL it won't appear in SQL Server.

[@melaniemurday3138]

Thanks for your reply. Is it possible to update both tables at the same time tho?

[@learnssis]

@@melaniemurday3138 using SSIS you can update both tables at the same time.

[@melaniemurday3138]

@@learnssis do you have a video whereby you explain how to do this pls?

[@learnssis]

@@melaniemurday3138 If you want to update 2 tables at the same time then use 2 execute sql task and do not connect them with each other this way they both will execute at the same time, now you can put the update queries in them and point to appropriate connection. This way when package will run they will be executed at the same time.

[@Tufail999]

Hi, tables has been migrate but data is not it's showing null in MySQL Can u please tell me what to do?

[@learnssis]

Did you get any errors ? Can you check the data between SQL and MySQL for a table ?

[@Tufail999]

@@learnssis Yes errors has come. But I follow proper step of the video didn't skip anything.

[@learnssis]

@@Tufail999 the errors might be due to data type not converted automatically between SQL and MySQL.

[@Tufail999]

@@learnssis ok i will check it thanks for helping

Thanks a lot my friend. Greetings from Turkey !

[@learnssis]

You are most welcome my friend Omer Faruk.

[@gerryc349]

Spot on sir! Thank you!

[@learnssis]

Thank you.

[@sivakumarbk2291]

Can we convert SQL DB hosted in Azure Services to MYSQL Azure Service.

[@learnssis]

Sorry I don't have any idea about this.

[@successpradhan13]

How to import my sql data file into SQL Server Datbase?

[@henrinoguem888]

Hi Sir i see you tutorial, it is very good. can you do the same thing with a Database so there are some Tables that have Indexes? Thank

[@learnssis]

Hi Henri, did you tried migrating a database with tables having indexes ? Are you getting issues with that ? I normally don't migrate the databases much. So far I have only migrated couple of databases from sql server to mysql. As they are different database management systems, thus there might be some limitations in migration.

[@macgaikwad]

Thanks sir, I used same procedure but in source database tables I used nvarchar(max) so migration wizard takes it as varchar(0), and when migrating data it gives error saying to long string. Instead it must replace to longtext, How to solve this error

[@learnssis]

Sorry I have not much used this wizard for migration, just used it couple of times, thus not sure about this error. If you have any question related to SSIS then you can let me know.

[@SachalChandio]

Life Saver.

[@learnssis]

Thank you Sachal.

[@pathakabhi11]

Thanks If i need to add comun in new database and operation and fill new column with new data For ex name column to firstname and lastname in new database and fill splite on space both new column

[@learnssis]

I think you can do that using sql queries. You can take help from chatgpt, it can give the queries to you to add the new column. Just give it the table name and the column name that you want to create. And then ask it to write the update query for you which will split the full name to first name and last name and will update the data to sql table. it can give all those queries to you, if you get any error then copy and paste the error back to it and it can give you the corrected queries.

[@pradnyakasar614]

If there is quantity is more then how to migrate that?

[@learnssis]

You can use SSIS to migrate huge data from SQL Server to MySQL.

[@TaskinDemirel]

Great work!

[@learnssis]

Thank you.

[@singamsubbarao4389]

I had migrated the same way but it skipped lot of tables then finally I found that those tables data types are not supported in mysql

[@learnssis]

Oh.

[@sameershaikh-fn3uc]

how to skipped that tables

[@mohammadmansour9390]

Thank you in advance

[@learnssis]

Thank you Mohammad Mansoor.

[@markdhelweb]

How to see view table? i have view table and data

[@learnssis]

Do you have view in sql server ?

[@phuan1101]

Thanks

[@learnssis]

You are most welcome.

[@shahroozolfatmehr2103]

thank bro

[@learnssis]

You are most welcome Shahrooz.

[@ebusiness7230]

thx

[@learnssis]

You are most welcome.

[@Rajesh-xf4cs]

hey nice tutorial but im getting a error can you please look Starting... Prepare information for data copy... Prepare information for data copy done Determine number of rows to copy.... Counting number of rows in tables... wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=grants_sql;DATABASE=;UID=sa" --source-rdbms-type=Mssql --source-timeout= --target-timeout=None --table-file=C:\Users ajesh\AppData\Local\Temp\tmp70m6_nrg --table [Grants] [dbo].[sysdiagrams] 19:38:51 [INF][ copytable]: --table [Grants] [dbo].[TBL_WORKFLOW_STATUS_MASTER] 19:38:51 [INF][ copytable]: Opening ODBC connection to [Mssql] 'DSN=grants_sql;DATABASE=;UID=sa;PWD=XXX' 19:38:59 [ERR][ copytable]: ODBC connection to 'DSN=grants_sql;DATABASE=;UID=sa;PWD=' failed 19:38:59 [ERR][ copytable]: Exception: SQLDriverConnect: IM008:10:[Microsoft][ODBC SQL Server Driver]Dialog failed Loading table information from file C:\Users ajesh\AppData\Local\Temp\tmp70m6_nrg ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 1 Failed like this can you help me with it thank you

[@Jinay.Kothari]

same error to me when doing bulk data transfer right

[@bryanwilly4086]

same

[@Jinay.Kothari]

@@bryanwilly4086 The only option is to make another database structure on phpmyadmin and convert the data to csv or other format so that it can be imported 😢😭

[@kishoracle]

are you reading a book ?

[@learnssis]

ha ha. Actually I want to make the video shorter because people don't want long videos, that's why I remove the pauses from the video during editing. But yeah I think there should be some pauses as well.

[@kishoracle]

Thank you. Sorry about the previous comment

[@learnssis]

@@kishoracleNo you are correct. I am trying to improve the new videos. Thank you.

[@uzairafzal6002]

How can I upload a 1GB SQL file on phpmyadmin. without splitting the file?

[@learnssis]

Sorry Uzair, I don't have any experience with phpmyadmin, never used it.

[@uzairafzal6002]

@@learnssis Can you just upload a video for migrating Sql database to Mysql

[@learnssis]

@@uzairafzal6002 I think this what we are doing in this video.

[@uzairafzal6002]

@@learnssis Can you kindly contact me through Google meet. I want your help

[@ronron7763]

awesome thanks

[@learnssis]

Thank you.

[@infotechsavvy4981]

I have 3 errors, any fix guys on this? Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_progress_page_widget.py", line 197, in thread_work self.func() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration_object_migration.py", line 117, in task_migrate self.main.plan.migrate() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\migration.py", line 510, in migrate self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog) SystemError: AttributeError("'NoneType' object has no attribute 'numericPrecision'"): error calling Python module function DbMssqlMigration.migrateCatalog ERROR: Migrate Selected Objects: AttributeError("'NoneType' object has no attribute 'numericPrecision'"): error calling Python module function DbMssqlMigration.migrateCatalog Failed

[@learnssis]

it looks like the migration is failing due so some data type mismatch, unfortunately I don't have much experience moving the whole data from SQL Server to MySQL. I would recommend to use the SSIS for data migration because there we can handle any kind of errors those might occur in the migration process. kzbin.info/www/bejne/n4SwZaeKpcmMnLs