bcp: Use string instead of Null RRS feed

  • Question

  • Im trying to import data from mssql server Mysql, I created schema on Mysql, For import the data I exported all the tables from mssql to CSV using BCP, then import the CSV to Mysql.

    bcp [db].[table] out C:\file.csv -c -k -t , -S server

    While importing CSV to Mysql Null values are converted to 0, So I want to change all null values to \N while copying from BCP.

    Please give me your suggestions.

    Monday, November 28, 2016 4:04 PM

All replies

  • Hi,

    following link will help you.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Monday, November 28, 2016 4:53 PM