Database delimited file mysql tab updating upload
This problem is even worse if any of your long fields contain multi-line text with newline characters in them.
My method in these cases is to use the BCP command-line utility to export the data from SQL server, then use LOAD DATA INFILE ..
Then, export the data from the MS-SQL side as follows. Now copy the files into /tmp on the My SQL server and load on the My SQL side like so: Don't forget that the tables (Table Name in this example) must be created already on the My SQL side.
(If you're using SQL Server Express, use a -S value like so: -S "Computer Name\SQLExpress") That will create a file named Table Name.dat, with fields delimited by ! This procedure is painfully manual when it comes to converting the SQL schema over, however it works for even the most difficult of data and because it uses flat files you never need to persuade SQL Server to talk to My SQL, or vice versa.
By using the INSERT INTO command you can insert the query results into table dbo. Here is another example where data is pulled from worksheet [Sheet1$] by using a SELECT * FROM command.
Again, by using the INSERT INTO command you can insert the query results into table dbo. The query can be any valid SQL query, so you can filter the columns and rows by using this option. This is another command that allows you to issue a T-SQL command to select data and again with the INSERT INTO option we can load data into our table.
INTO TABLE command in My SQL to read the data file back in.
BCP is one of the oldest SQL Server command line utilities (dating back to the birth of SQL server - v6.5) but it is still around and still one of the easiest and most reliable ways to get data out.
See the End-of-life announcement for My SQL GUI Tools (which included the Migration Toolkit): SQL maintain archives of the My SQL GUI Tools packages: Name\" (use only Instance Name).
You can use My SQL Workbench which provides a way to quickly migrate data and applications from Microsoft SQL Server to My SQL employing less time and effort.