How to add scripts to C# package project

ISRAELISRAEL Posts: 4
edited August 11, 2011 3:33PM in SQL Packager Previous Versions
Hi there

I’m a newbie. I just want to know how to add a script to the C# Package project. I have some scripts that I have to run before the sync script produced by packager wizard.

Thanks
Israel

Comments

  • Thanks for your post.
    The SQL that is created by packager is stored as resources in the C# project, and I don't think you can easily amend these. The generated application does support the /presql and /postsql commands though, so you can supply a .sql script as a commandline option when executing the built package.

    If you wanted to incorporate the extra commands directly into your package when compiling, it's perhaps a little trickier and not something i've tried before.
    A look at the project shows that the /presql and /postsql switches set a couple of properties in the PackageExecutor class. You'll see the Execute method in there calls:
    RunSQLFile(PreSqlFile, "Running pre-processing script")
    

    The RunSQLFile method is responsible for loading the commands from the file and then passing them to the "ExecuteSQLCommand" method, so i'd look at implementing something around this area to suit your needs - for instance running some commands hard-coded into the app.

    Hope that helps.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.