Phase I of Catalog Validator tool. 

Set DatabaseGenerator as StartUp Project and set database connection strings in App.config of the same project.

You don't need to create a Server object, that's for SQL Server Management APIs (to do things like create databases and other Server-level administration). Instead, SqlConnection has a "CreateCommand" method. Use that and fill in the CommandText property with the SQL you want to execute. Then call ExecuteNonQuery on the command and you're all set!