Exporting structure to MSSQL.

[jason cipriani-2]

I'm trying to export data to MSSQL, but "MSSQL compatibility mode"
isn't actually MSSQL compatible at all. For example:

CREATE TABLE "agroups" (
  "agroup_id" int(11) NOT NULL,
  "account_id" int(11) NOT NULL,
  "name" varchar(32) NOT NULL COMMENT 'group name',
  "desc" text,
  PRIMARY KEY  ("agroup_id"),
  KEY "ACCOUNTID" ("account_id")
);

MSSQL doesn't support "COMMENT" like that, nor does it support "KEY"
(phpMyAdmin *should* be exporting CREATE INDEX queries...).

How do I make this work? Why isn't "MSSQL" compatibility MSSQL-compatible?

I've already looked at this:

http://pjhile.com/mysql-to-mssql-with-phpmyadmin

But that guide is far from satisfactory. For example, steps 6, 7, and
8 all remove important structure info that I'm trying to export...

Thanks,
Jason

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users

[Marc Delisle]

We rely on MySQL's SQL mode feature, see
http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html
so I suggest you report a bug on bugs.mysql.com

Jason Cipriani a écrit :

> I'm trying to export data to MSSQL, but "MSSQL compatibility mode"
> isn't actually MSSQL compatible at all. For example:
>
> CREATE TABLE "agroups" (
>   "agroup_id" int(11) NOT NULL,
>   "account_id" int(11) NOT NULL,
>   "name" varchar(32) NOT NULL COMMENT 'group name',
>   "desc" text,
>   PRIMARY KEY  ("agroup_id"),
>   KEY "ACCOUNTID" ("account_id")
> );
>
> MSSQL doesn't support "COMMENT" like that, nor does it support "KEY"
> (phpMyAdmin *should* be exporting CREATE INDEX queries...).
>
> How do I make this work? Why isn't "MSSQL" compatibility MSSQL-compatible?
>
> I've already looked at this:
>
> http://pjhile.com/mysql-to-mssql-with-phpmyadmin
>
> But that guide is far from satisfactory. For example, steps 6, 7, and
> 8 all remove important structure info that I'm trying to export...
>
> Thanks,
> Jason
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Phpmyadmin-users mailing list
> Phpmyadmin-users@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users
>

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users