phpmyadmin/phpmyadmin — pull request #88 by hastenax (2012-08-02 12:42:23+00:00)
Title: Extended MSSQL compatibility features.

In order to ensure compatibility to export in MSSQL compat mode I suppose some features:

1. MSSQL doesn't support backquotes(which are default for pma export options). I replace them with ".
2. MSSQL doesn't have DATE type. I replaced it with DATETIME.
3. MSSQL doesn't have unsigned attribute. So I removed them from exported text.
4. MSSQL doesn't support direct ID inserting which are IDENTITY fields (AUTO_INCREMENT). So we need to ON and OFF IDENTITY_INSERT query for each table.
5. MSSQL doesn't support length for INT fields. I removed them.

All this work helps me to convert real working mysql db to mssql one only without INDEXES, because of MSSQL have another syntax.

@todo - rewrite KEY (CREATE INDEX in MSSQL) and UNIQUE (CREATE CONSTRAINT in MSSQL).