Validate a code written by students

Question

I teach SQL Programming in an university. I was thinking to create a submit page that they could upload the .sql file and it automatically checks if the requirements were met, such as creating a database, using a custom CLR dll and so on.

Does anybody have experience in creating that? I got a server running Windows for that.

Thanks in advance

Answer 1

I think it would be fine as long as a separate account and database is created for each user who only has permissions granted for their database so they can't mangle other stuff with SQL injection.

I'd personally check it with a php script or something as writing a dll seems like overkill. You could give them a webform, run the queries, then have the script run another set of queries afterward that validates the database state and send them to a page displaying the result.