Hi Guys,

Is it easy to migrate a SqlServer 2005 database to MySql? Has anyone done this? Have any suggestions?

Cheers,

Pete

The schema should be identical, and then you'll have to regenerate the code against the MySQL database.

Thanks Walaa,

Is there an easy way to port the schema over? I heard mention of some llblgen ddl scripts - would these do the job?

Cheers,

Pe

Yes these are the **DDL SQL templates **. You can found them in the Tasks and Temnplates section of v.2.5 or v.2.0 download page.

You can download from MySql a database migration tool which will do it for you. Beware of some 'basic' things which are not present in MySql.

1) No concept of a default value. For example, you cannot have GetDate() as the default value for a DateCreated column. (To recreate this functionality, you will have to do it in a trigger) 2) While it has the ability to specify constraints (foreign keys, etc), it does NOT ENFORCE them. Sort of like removing the police from the roads! 3) All your stored procs and triggers will have to be rewritten.