i used to use import/export wizard for transferring data over two sql server 2005 servers, where now i want to do it between MySQL and sql server 2005, where it seems as am using MySQL ODBC connector then the wizard does not give me an option for columns mapping so i have to write the script my self where am not familiar with that, so am looking for a script to perform the following:
- delete all records on destination table
- import all records from source table
- convert the columns types for the source tables (as it is differ than destination columns types)
plz if u have any similar link then provide, thanks ....