PJ Hile

A client has forced me to migrate a MySQL database to MSSQL. Using PHPMyAdmin here is a list of things I had to do in order to get the data over:

1. ‘SQL compatibility mode’ to ‘MSSQL’
2. Uncheck ‘Add AUTO_INCREMENT value’, ‘Enclose table and field names with backquotes’, ‘Complete inserts’, ‘Extended inserts’
3. Remove all occurrances of ‘unsigned’
4. Replace ‘id int(10)’ with ‘id int(10) IDENTITY (1,1) PRIMARY KEY CLUSTERED
5. Replace all ticks (`) with quotes (”)
6. Remove all PRIMARY KEY lines
7. Remove all KEY lines
8. Remove all ENUM data types
9. Remove lengths from all int types (int,smallint,tinyint)
10. Replace date with datetime
11. Replace tinytext with text
12. Remove all ‘\r\n’