SSDT Post-Deployment script (data dump with JQuery) - disable variable substitution

Question

In my SSDT project I have a post deployment script where I include a script file.

:r .\Data\Data.Content.sql

The file Data.Content.sql is a dump of the database (insert statements) and it contains content like 'var $sameHeightDivs = $(''.product-tile-region'');'. The database contains JQuery scripts. So I receive the following errors:

SQL72008: Variable document is not defined. or 72006: Fatal scripting error: Incorrect syntax was encountered while parsing '$(''

I found that you can disable 'disable variable substitution' with the argument -x.

But is there a way to define this somewhere? (post-deployment script? project setting?)

Or is there another way to solve this problem?

FYI: to create the dump I use Microsoft.SqlServer.Management.Smo.Scripter.

Kind regards,

bob

Wow, it seems the SSDT team really hate people who use jQuery! — Rory
– Rory, Commented Dec 18, 2015 at 11:31

bob · Accepted Answer · 2013-02-06 10:24:34Z

1

I posted the same question in the SQL Server Data Tools forum where someone came with a workaround.

After the script generation I do a search and replace for the $ char.

function SearchAndReplace($file) {
    (Get-Content $file) | 
    Foreach-Object {$_ -replace "\$\(", "' + CHAR(36) + '("} | 
    Set-Content $file
}

I included the '(' to be sure to limit the scope (to JQuery selectors).

answered Feb 6, 2013 at 10:24

bob

6,4851 gold badge33 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSDT Post-Deployment script (data dump with JQuery) - disable variable substitution

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related