embed bulk data for post-deployment script in sql server data tools (SSDT) -
in class libraries possible use embedded resources , access them in code.
can use embedded resources (e.g. tab separated text files) in ssdt use them 'seeding data' in post deployment script? prefer not use hard-coded paths.
as can not that, since scrip execute @ sql server has no access local drive file is. have done before copy file inside script variable xml type.
example: declare @x xml = n '..........' , manipulate variable insert in desired table.
Comments
Post a Comment