I need to write a module that will perform a number of tasks on a SQL database. I know I can enter the SQL queries as strings but since some of them are longer scripts it would be much cleaner if I could include a sql script file to reference.
If I include the SQL script file in the module folder and include it in the FileList attribute of the module manifest, should the SQL script file be included when I publish the module to a local repository? If so, should functions in my module be able to reference the sql script when using Invoke-Sqlcmd with the -InputFile parameter?