Our old tables have varchar fields. We want to convert them to nvarchar so that we can handle Unicode data.
For each table I create a corresponding new table with the name TableName_Uni with the same structure, except for nvarchar fields instead of varchar.
Now I try to bcp the data out/in:
bcp dbName.dbo.TableName out c:\temp\TableName.bcp -w –T
bcp dbName.dbo.TableName_Uni in c:\temp\TableName.bcp -w –T
Sometimes it works, but sometimes the data in the TableName_Uni does not match the data in TableName!
I tried using -c and -N instead of -w with the same wrong results.
Is there something I'm doing wrong? Or bcp is simply not going to work if the tables have different structure?