search

himselfv / jet-tool

MS Jet database schema export/SQL execution tool
21 stars 3 forks source link

[Solution] Create MySQL dump [It is no Issues] #16

Open tecdoc-ukr opened 6 months ago

tecdoc-ukr commented 6 months ago

It is no Issues! It is Solution describe. I use this "jet-tool" for export mdb databases to MySQL dump files in command line. "jet-tool" helps me a lot in this. The resulting dump file produced by "jet-tool" needs to be slightly adjusted. For this I use "fnr.exe --cl" utility (Find and Replace Tool). Here is an example of some operation with "fnr.exe --cl" on schema dump fule:

:: replace for schema 
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find " COUNTER " --replace " SMALLINT UNSIGNED "
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find " TEXT(" --replace " VARCHAR("
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find "[" --replace ""
fnr.exe --cl --dir "%ResDest%" --fileMask "*%FileMysql%" --find "]" --replace ""

Thank you author for "jet-tool" !