Activity overview
Latest activity by DotMedic
Hi,
I tried to use Export Comparison Results (only inserts) to generate CSV files of my Test data. This should work with following SQL statement but the csv file is wrong.
BULK INSERT [DOK_FRASER]
FROM 'c:\Temp\DOK_FRASER.csv'
WITH
(
FieldTerminator = ';',
FIRSTROW = 2
)
GO
There are 2 problems with generated CSV file...
First is that the generated CSV file is doubling the columns (column names are doubled, the values are)
"FRASLOPNR";"FRASNAMN";"FRASNAMN";"FRASTEXT";"FRASTEXT";"GILTIGFROM";"GILTIGFROM";"GILTIGTOM";"GILTIGTOM"
"30";"Injektion ";"";"Injektion Behephan 1mg/ml, 1 ml subcutant.";"";"2008-05-06 00:00:00";"";"";""
the correct rows should look like
"FRASLOPNR";"FRASNAMN";"FRASTEXT";"GILTIGFROM";"GILTIGTOM"
"30";"Injektion ";"Injektion Behephan 1mg/ml, 1 ml subcutant.";"2008-05-06 00:00:00";""
Secound issue is scripting of values that are blobs. The BLOBs are not generated correctly. The value is scripted as "<Binary Data...>" instead of the real data.
Is this known\reported bug?
Regards,
Sanjin / comments
Hi,
I tried to use Export Comparison Results (only inserts) to generate CSV files of my Test data. This should work with following SQL statement but the csv file is wrong.
BULK INSERT [DOK_FRASER]
...