RE: converting MS SQL to MySQL

Hawk Sun, 09 Feb 2003 04:13:33 -0800

At 04:13 PM 2/7/2003 +0000, you wrote:

We sell a data converter for this purpose check out www.bpenet.net

I'm not concern about transferring the data. I was having problems creating the indexes.

thanks for the reply...

Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
Tel/Fax: 0870 922 0247
email: [EMAIL PROTECTED]
websites: www.humphreyconsulting.co.uk & www.bpenet.net


-----Original Message-----
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2003 3:03 PM
To: [EMAIL PROTECTED]
Subject: converting MS SQL to MySQL



Hi,

I am new to SQL.  I am attempting to create a database that was created
in
MS SQL to MySQL.  The below SQL statements works with MS SQL.

I am executing the following:

CREATE TABLE 'Accounting'(
        'Username' VARCHAR(254) NULL,
        'CallerID' VARCHAR(128) NULL,
        'Addr' VARCHAR(128) NULL,
        'NAS' VARCHAR(128) NULL,
        'Port' VARCHAR(128) NULL,
        'Start' DATETIME NULL,
        'Stop' DATETIME NULL,
        'SessionTime' INTEGER DEFAULT 0,
        'ExtraTime' INTEGER DEFAULT 0,
        'TimeLeft' INTEGER DEFAULT 0,
        'KBytesIn' INTEGER DEFAULT 0,
        'KBytesOut' INTEGER DEFAULT 0,
        'SessionKB' INTEGER DEFAULT 0,
        'ExtraKB' INTEGER DEFAULT 0,
        'KBytesLeft' INTEGER DEFAULT 0,
        )
GO

CREATE INDEX IX_Username ON Accounting(Username)         <---- MySQL
will
not take this command
GO

CREATE TABLE 'ActiveUsers'(
        'UserID' VARCHAR(254) PRIMARY KEY,
        'NAS' VARCHAR(128) NULL,
        'Port' VARCHAR(128) NULL,
        'Username' VARCHAR(254) NULL,
        'CallerID' VARCHAR(128) NULL,
        'Address' VARCHAR(128) NULL,
        'LoginTime' DATETIME NULL,
        )
GO

CREATE TABLE 'TAC_GRP'(
        'TAC_ID' VARCHAR(254) NOT NULL,
        'TAC_Attr' VARCHAR(64) NOT NULL,
        'TAC_Val' TEXT NULL
        )
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr)  <---- MySQL
will not take this command
GO

CREATE TABLE 'TAC_USR'(
        'TAC_ID' VARCHAR(254) NOT NULL,
        'TAC_Attr' VARCHAR(64) NOT NULL,
        'TAC_Val' TEXT NULL
        )
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) <---- MySQL
will
not take this command
GO


Thanks in advance.

---
[This E-mail scanned for viruses by Friend.ly.net.]


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]
com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---
[This E-mail scanned for viruses by friend.ly.net.]

---
[This E-mail scanned for viruses by Friend.ly.net.]


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: converting MS SQL to MySQL

Reply via email to