List:General Discussion« Previous MessageNext Message »
From:Kranthi Date:August 13 2010 11:05am
Subject:RE: Migration
View as plain text  
Hi Lenz,
        I used UUID() function, I am getting error "Check the manual that
corresponds to your mysql server version for the right syntax to use near
UUID()". I am using mysql version 5.0.45.


DROP TABLE IF EXISTS `AdventureWorks_HumanResources`.`Employee`;
CREATE TABLE `AdventureWorks_HumanResources`.`Employee` (
  `EmployeeID` INT(10) NOT NULL AUTO_INCREMENT,
  `NationalIDNumber` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci
NOT NULL,
  `ContactID` INT(10) NOT NULL,
  `LoginID` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT
NULL,
  `ManagerID` INT(10) NULL,
  `Title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BirthDate` DATETIME NOT NULL,
  `MaritalStatus` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT
NULL,
  `Gender` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `HireDate` DATETIME NOT NULL,
  `SalariedFlag` TINYINT NOT NULL DEFAULT 1,
  `VacationHours` SMALLINT(5) NOT NULL DEFAULT 0,
  `SickLeaveHours` SMALLINT(5) NOT NULL DEFAULT 0,
  `CurrentFlag` TINYINT NOT NULL DEFAULT 0,
  `rowguid` VARCHAR(64) NOT NULL DEFAULT uuid(), -- Here I am using UUID()
instead of newid()
  PRIMARY KEY (`EmployeeID`)
)
ENGINE = INNODB;



Thanks & Regards, 
 Kranthi 



-----Original Message-----
From: Lenz Grimmer [mailto:lenz@stripped] 
Sent: Friday, August 13, 2010 3:56 PM
To: mysql@stripped
Subject: Re: Reg: Migration

Hi,

On 08/13/10 09:34, Kranthi wrote:

>          I am migrating the database from mssql server to Mysql.i am
getting
> problem with newid(),I don't know about newid(),i am using mysql migration
> tool kit.
> 
> if anybody knows please help me. 

Would using the UUID() MySQL function work for you in this case?

http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html#function
_uuid

Bye,

    Lenz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1



-- 

Thread
Reg: MigrationKranthi13 Aug
  • Re: Reg: MigrationLenz Grimmer13 Aug
    • RE: MigrationKranthi13 Aug
      • RE: MigrationJohn Daisley13 Aug
  • Re: Reg: MigrationJoerg Bruehe13 Aug