locked
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.

    http://stackoverflow.com/questions/30132681/bcp-retaining-null-values-as-n


    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