I have scripts generated from a MySQL database using phpmyadmin to create database and insert data. The scripts were exported using compatible with MS SQL. Needless to say they are not compatible at all, transaction is open using
I tried compatibility level 100 (I'm using latest SQL Server Express), doesn't work.
I cannot install MySQL and cannot contact the software provider or database creator.
I am planning to use notepad++ to find and replace unless there is a better way. Questions are:
- is there a better way?
- What should I look for to find and replace (assuming someone has done that before)?