Adding a new filter to not drop Entire Database(clearInsteadOfDropCreate)

[HarshithaKumaresan]

I need to add a filter in post process of SQL command to not drop entire Database rather Update it.

The code consist of a property "clearInsteadOfDropCreate" where it does not delete the entire DB. But how do we use this in the script(syntax for clearInsteadOfDropCreate ) ?

Presently I have installed "ExperienceExtractor-0.3.1-8.2.zip" Package. Is there an updated sitecore package that allows the user to not delete the entire DB, only delete the tables.

[hermanussen]

Well, I implemented it and the PR got accepted here: https://github.com/Sitecore/experience-extractor/pull/13 (merged on Jan 17, 2017)

But the latest release is from Dec 15, 2015. So I guess you should just get the sources and build that. Shouldn't be too hard.

Note that this tool has not been updated in quite a while, and may not work with more recent versions of Sitecore.

[HarshithaKumaresan]

Thanks so much for the update.

I have problem building the solution, doesn't load nuget packages properly. I just installed the package in my instance. May I know if there is some syntax of passing for "clearInsteadOfDropCreate" as true in the script :-

Example : postprocessors": [ {"mssql": {

        "connection": "Server=.\\SQLEXPRESS;User Id=sa;Password=(password)",
        "createDatabase": "Example" ,

"clearInsteadOfDropCreate":"true" //This did not work for me. Is there some syntax to set the property as true on execution? }} ]

[hermanussen]

Do you have the Sitecore MyGet feed setup correctly (https://sitecore.myget.org/gallery)? I think it didn't work for you because you installed the package, which doesn't support it yet (as implied earlier, the latest package is not up to date with the latest changes).