导入sqlserver数据到mysql，导入sqlservermysql

导入sqlserver数据到mysql，导入sqlservermysql

我现在有个需求,需要将部分数据库从sqlserver迁移到mysql.

目前在mysql中表已经建立完成,接下来就是将数据导入至mysql.

有几个问题:

1:是否可以使用BCP OUT将sqlserver的数据导出,再导入到mysql.

2:我使用

EXEC xp_cmdshell 'bcp "SELECT * FROM [dbo].LotTestTemplateXChip" queryout C:\LotTestTemplateXChip.txt -T  -n '

拿出来,再到mysql使用load data infile,进去的数据不对.

在BCP OUT中是否可以将数据BCP成可读的格式(列之间使用空格间隔).

我使用上面的sql BCP出来,发现根本无法读取.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
Don't think so, but you can put all dump commands in single batch file and just execute that batch file.