Rank: Newbie
Joined: 7/13/2016 Posts: 5 Location: UK
|
Hi, I have some relatlivly complex XML data (several GB without schema). The generated SQL Server DDL us varchar(255) for most fields, which unfortunalty is insufficient for many, which is consequently followed by data truncation errors.
There are two workarounds I am familer with (both are time consuming). 1. Define a schema 2. manually fix the DDL and try again.
Is there another method of telling XMLSpy that default datatype for SQL Server varchar should be varchar(max) and not varchar(255)?
Any comments would be highly appreciated.
|