How to import data to mysql db?

I need to import data to mysql,

and idea abt that?

thanks

SSIS does not have an ODBC destination for MySQL, but you can write one with very few lines of code (see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=106559&SiteID=1)

If you'd rather use third-party tools, this might be helpful http://www.webyog.com/en/sqlyog_migration_toolkit.php

Be wary of common pitfalls around types (e.g. SQL Server's VARCHAR data type can hold up to 4,000 characters, while MySQL's VARCHAR can only hold up to 255 characters).

|||MySQL has an ODBC connector which CAN be used with the DataReader Source though.

How to implement Spatial Index in SQL Server?

Any one has an idea?

How should I implement R-Tree spatial index in SQL Server?

My idea now is to create UDT for my spacial coordinate and then I need the index on that UDT. How should I start?

? Start here: http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2005-122 -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Pi314159@.discussions.microsoft.com> wrote in message news:1f35e2cf-f9e8-4e69-b2db-cba6da61ed8a@.discussions.microsoft.com... Any one has an idea? How should I implement R-Tree spatial index in SQL Server? My idea now is to create UDT for my spacial coordinate and then I need the index on that UDT. How should I start?|||Thanks for this pointer - We have implimented an R-Tree Bulk loading algorithm for a project we are working on but it is only held in memory. This implimentation lloks perfect for the larger datasets we expect to meet. I cannot find the download sample though - any clues?|||? It's part of this set: http://www.microsoft..com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <Paul Dorey@.discussions.microsoft.com> wrote in message news:14d3d799-73aa-455f-96e2-b92bf523c0d5@.discussions.microsoft.com...Thanks for this pointer - We have implimented an R-Tree Bulk loading algorithm for a project we are working on but it is only held in memory. This implimentation lloks perfect for the larger datasets we expect to meet. I cannot find the download sample though - any clues?