Improved defncopy utility, mainly fixing quoting.
Added commits
defncopy: Use memory instead of temporary file
Index script is not that huge, just allocate in memory.
defncopy: Fix MS column length for N(VAR)CHAR types
The length from sp_help is in bytes, not in code units.
defncopy: Quote strings and identifiers
Allows to handle weird characters (like spaces) in strings and identifiers.
Handle memory marking in a list to easily free. I plan to move that part of code to common code.
defncopy: Trim spaces around nullable flags
This fix detection of nullable columns for Sybase.
defncopy: Fix for order of index recordset
The order of columns is different between MS and Sybase.
Also separate code in a function, it was too long.
defncopy: Quote key index names
Split index keys considering current column names.
This is more complicated than just split considering separator (command and space, ", ") however it supports weird cases where we have the separator in the middle of a column name.
defncopy: Add test for the applications
Use commands calling programs.
Mainly use tsql to create some table, output definition with defncopy and check definition is as expected.
Caution
Do not use Source code links below, they are auto generated and broken.