migrated from sqlserver2005 to mysql

[kkshansid]

kindly help me to provide important link as i migrated from sqlserver2005 to mysql
sqlserver offers many facilities such as
easy importexport from sqlserver to any formate access excel etc
copy paste data to database
query designer to design query easily
but i can not to any of the works in mysql

[wizardry]

try this out at: www.mysql.com/downloads

they have a migration tool their for the conversion.

hope this helps.

theo

[Canabeez]

Can't you dump the database from sqlserver2005 into *.sql file and then import it into mysql...?

[wizardry]

i dont suggest it its to differant formats. the migration tool for sql to mysql takes procedures, functions, modules, schemas, etc... buts them in mysql format for the migration.

its like going from a windows platform to linux platform its not going to happen with out some sort of migration process.

i suggest using the tool so that you don't destroy your sys or system hive in mysql.

hope this helps.

theo werntz ii