How do you deploy SQL Scripts

Hello

What do you use to deploy sql scripts for a continuous integration process? I want to write either

  1. an app with drop down for all environments then point to folder where scripts folders for specific project exist
  2. automate this process using power shell or some other scripting language, same as #1 where it iterates a folder and deploys

Any recommendation?