S
S
Sergey Melnikov2015-10-27 11:02:47
MySQL
Sergey Melnikov, 2015-10-27 11:02:47

How to insert records from sql server into mysql?

Greetings.
I cannot understand in what a problem...
I Do insert into mysql table from select sql server table.
When inserting fields in varchar format without longtext, everything is inserted normally. When inserting varchar + longtext , the varchar is filled with null s. That is, I take from mssql nvarchar 255+ nvarchar max is inserted into varchar + longtext on the mysql side via an odbc link. And so values ​​of fields varchar, mysticism are lost.... Help!
In general, the link behaves strangely, when adding a field with varchar max to longtext, it fails with a fatal error.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2015-10-27
@azazel_live

and to select a file in SQL and then import?
stackoverflow.com/questions/3917081/how-to-export-...
www.thegeekstuff.com/2014/03/mssql-to-mysql

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question