|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 12/05/2010 : 13:12:07
|
>> in sql format?
Try using bcp or ssis to export to a csv or such like file then import.
Otherwise you should be able to create an odbc connection t mysql and use it in ssis to insert.
Could probably also use a linked server.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
Exporting Data
