[BUG] Dump SQL Server encoding error

[Drilmo]

I think there's an encoding error when dumping the structure and the data, in fact in the inserts for the values & I had & on nvarchar which crashed the insert request, I had to apply a replace following the following regex :

(N'(?:[^']|'')&)(amp;)((?:[^']|'')')

And replace with group 1 and 3 to remove the amp;

[cweijan]

The single quote ' is not escaped. What other wrong symbols have you encountered? I will fix it in the next version.

[Drilmo]

When the value contain & he is exported as & and it not work on insert.

Another problem, when I dump structure and data, in the create table all field names are enclosed in double quotes, but not in insert into, which poses a problem when there are spaces or ' in the field name when inserting into.
You'd have to either enclose them in “ or square brackets.