there is a dump base danich ms sql file some.bak how to convert data from a file to mysql in a linux environment
- Fully no way. At least because the description of the structure of the table, not to mention the functions and triggers - Anton Skorodumov
- 2no way. there is no direct way. It is necessary to view each table manually, to come up with the correspondence of the data types of one database to the data types of another. after that, write a script that will change the syntax for the designation of names (at least replaces the square brackets with reverse apostrophes). pozhamanit with the syntax to create a contraint, remove from the script is not supported in MySQL features (or replace them with something). And yes, the source file should be in the format of sql commands, and not a binary data dump. - Mike
|
1 answer
For migration tasks with MS SQL, the MySQL Workbench utility is recommended.
Use the migration guide to learn about the migration process.
minamoto minamoto
3,981 9 nineteen
- I watched but could not find a way to convert from the dump, only directly from the server and I need to do the conversion from the dump - vov4ok
- 2@ Vov4ok, you do not have a dump, but a backup. You cannot convert from it. Raise the server, restore the backup and then migrate. - minamoto
|