I am currently working with Team city to build my MVC application and used as my continous integration platform.
Within my solution I have an mvc project and a database project. Team city builds both and from the mvc project, a nuget package is created. As part of the database project, I have a build event that runs a powershell file that generates a database script.
Is it possible in the team city setup to output this script as part of its output and if so, how?
Have a look at Teamcity Build Artifacts: you will find the generated script in the "Artifacts" tab at the end of the build run.