from SQL Server, pointing to specific database, then, Task, -> Export Data...
it comes out with this SQL Server Import and Export Wizard:
The data type could not be assigned to the column "xxxxxxx" in ".NET Framework Data Provider for MySQL".
it seems it is not that straightforward to export database from one database server to another.
any useful comments would be appreciated.
1 answers
as far as I know it's meant to export from one sql server to another.
not all sql databases are directly portable. most (that I've worked with) have to be edited, and data types changed to be usable.
mysql has its own data provider (done by mysql) which you should use, sql has the sql client built into .net, oracle has its own (done by oracle) which you should also use.
the easiest thing I've been able to do the export from one to the other is to write an app to pull all the data from one db using the native provider, create rules for data type conversion (sql server -> C# -> db X), then insert into the other db using its native data provider.
good luck.
answered one year ago by:
2309
494
thanks for your comments