Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2009-10-07 : 03:03:30
|
| Can I use select into statement to copy mssql table to mysql table ?It has been few weeks finding the solution.Any advice is appreciated .thanks. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-10-07 : 03:05:54
|
| Add mysql as linked sereverSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-10-07 : 03:43:48
|
| Is this a one-time-deal or do you need to do it on a regular basis? The most efficient would probably be to dump the table in to a csv-file using BCP and then import to MySQL with a LOAD DATA INFILE statement...- Lumbagohttp://xkcd.com/327/ |
|
|
|
|
|
|
Copy mssql table to mysql