distal-attribute
distal-attribute
distal-attribute
distal-attribute

Bug Reports

whizster posted 2 years ago in General
Hello, i just found your program and it looks great, but i found a couple bugs which have made it unusable for me. I have a series of servers from MS SQL 7 & MS SQL 2008, and i'm trying to migrate them all over to MySQL.

In relation to this, i found the following issues:

When exporting a table as SQL the script it creates errors out. It appears to be related to the field type of "text" which is a large blob of text/data (mysql's equivalent of a medium text variable field)

when i have already created the table and database and just attempt to use it for datatransfer it errors out by not enclosing the text fields within quotes. It encloses all of the varchar fields just fine, just not the text fields. for example of generated script:

--------------------

INSERT INTO "SiteNews" ("Entry", "Site", "PostTopic", "PostDate", "PostBy", "PostEmail", "Post") VALUES
(1, 'CS', 'CS 1.5 Release!!', '2002-12-23', 'Com', 'None', Today is the BIG day, CS 1.5 is being released!! We'll have a release party for it and the second the new version is released we will have the Download links available in the channel and on this site, Stay Tuned.),

--------------------

It also appears MySQL is having issues with the quotes and the uppercase letters in tablenames & feild names.. so maybe an lcase or equivalent conversion when going from mssql > mysql would be wise, as in MS we can use uppercase things etc.

Lastly some way to do a field conversion mapping, as MS SQL has "SMALLDATETIME" which MySQL doesn't, so having that converted to "DATETIME" would also be good..

Example output:

-- Dumping structure for table SiteNews
DROP TABLE IF EXISTS "SiteNews";
CREATE TABLE IF NOT EXISTS "SiteNews" (
"Entry" SMALLINT NULL,
"Site" VARCHAR(10) NULL,
"PostTopic" VARCHAR(255) NULL,
"PostDate" SMALLDATETIME NULL,
"PostBy" VARCHAR(50) NULL,
"PostEmail" VARCHAR(255) NULL,
"Post" TEXT(16) NULL
);

Please login to leave a reply, or register at first.