MSSql & MySQL

Hi there,

I am busy converting a MSSql database creation script to a MySQL database creation script.

Everything is going reasonably well except I can't get MySQL to make the following work.

CREATE TABLE tTasksMy (
intTaskID int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
vchTaskDesc text NULL
)

MySQL complains about the IDENTITY (1,1) bit. Anyone have any ideas ?

Thanks

Jmysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT (http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html)|||Thanks ! -- Works like a charm!

Originally posted by r937
mysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT (http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html)sql

Msgbox/Breakpoints not working in a script component.

In the code behind the Script Transformation component, neither the MsgBox nor any of the breakpoints seem to work. Am I missing to do something in order for these to get executed?

Thanks.

Andy.

No, you're right. Breakpoints and msgboxes do not work in script components.

-Jamie

|||So how do we debug code?|||

Best way is to throw information events that appear in the output window.

I can't remember the syntax offhand but if you type "Me." intellisense will guide you.

Thinking about it I think its "Me.FireInformation(...)"

-Jamie