07 How to Migrate SQL Server database to MySQL
HTML-код
- Опубликовано: 14 ноя 2021
- How to Migrate SQL Server database to MySQL
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
MySQL Migration Tutorials: • MySQL Migration Tutorials
SSIS Tutorials: • SSIS Tutorials
How to Migrate SQL Server database to MySQL
How do I import a SQL Server database into MySQL?
How do I convert MSSQL database to MySQL step by step?
How do I migrate a SQL database?
How do I migrate my database?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com” Наука
This is just perfect!
Well detailed explanation.
Much appreciated!
Thank you so much Great Cars.
Thank you sir, Cause of this video i solve my problem's from company. Big thanks
Glad to know Jogi that it helped you.
Worked like a charm, cheers.
Wow good to know that Dante.
Thanks a lot my friend. Greetings from Turkey !
You are most welcome my friend Omer Faruk.
Spot on sir! Thank you!
Thank you.
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?
Thank you. Well explained and good teacher. Good karma to you !
Thank you.
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.
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.
Great work!
Thank you.
Thank you in advance
Thank you Mohammad Mansoor.
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
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.
Life Saver.
Thank you Sachal.
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?
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.
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.
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.
How to import my sql data file into SQL Server Datbase?
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
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.
What if I use localdb instead of Microsoft SQL Server and I get an error SQL Server: 17?
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.
Can we convert SQL DB hosted in Azure Services to MYSQL Azure Service.
Sorry I don't have any idea about this.
thank bro
You are most welcome Shahrooz.
Thanks
You are most welcome.
How about migrate database, if have million data in production, and database already use by system every time. Because live.
I would suggest using SSIS to migrate the data in that scenario.
ruclips.net/video/iSM4tTpdYfY/видео.html
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
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.
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
Oh.
how to skipped that tables
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
It is a one side migration. The row that you will add to MySQL it won't appear in SQL Server.
Thanks for your reply.
Is it possible to update both tables at the same time tho?
@@melaniemurday3138 using SSIS you can update both tables at the same time.
@@learnssis do you have a video whereby you explain how to do this pls?
@@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.
If there is quantity is more then how to migrate that?
You can use SSIS to migrate huge data from SQL Server to MySQL.
awesome thanks
Thank you.
Hi, tables has been migrate but data is not it's showing null in MySQL
Can u please tell me what to do?
Did you get any errors ? Can you check the data between SQL and MySQL for a table ?
@@learnssis Yes errors has come. But I follow proper step of the video didn't skip anything.
@@Tufail999 the errors might be due to data type not converted automatically between SQL and MySQL.
@@learnssis ok i will check it thanks for helping
thx
You are most welcome.
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
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.
How to see view table? i have view table and data
Do you have view in sql server ?
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
same error to me when doing bulk data transfer right
same
@@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 😢😭
are you reading a book ?
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.
Thank you. Sorry about the previous comment
@@kishoracleNo you are correct. I am trying to improve the new videos. Thank you.
How can I upload a 1GB SQL file on phpmyadmin. without splitting the file?
Sorry Uzair, I don't have any experience with phpmyadmin, never used it.
@@learnssis Can you just upload a video for migrating Sql database to Mysql
@@uzairafzal6002 I think this what we are doing in this video.
@@learnssis Can you kindly contact me through Google meet. I want your help
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
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.
ruclips.net/video/iSM4tTpdYfY/видео.html
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
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.