Few weeks ago, one of our projects went online for beta testing. Its a SaaS app and follows the one database per customer model. To standardize the process of creating a new customer we decided to use the new SQL Server power shell (sqlps) script. This shell is free can be obtained by downloading SQL Server Management Studio 2008 Express.
We kept our database scripts in VS.net database projects. Idea is to create the database with sql scripts everytime before running the unit tests. This way we can detect any mistakes in the sql server scripts. We wrote two power shell scripts. First one to combine all the sql scripts together into a file and the other one to drop and create the database. Integration with CC.net was done using the Executable Task in CC.net.
MySQL – Fix – Error – Your Password does not Satisfy the Current Policy Requirements - Just the other day I received an email from a MySQL user who has been struggling to set up his password due to the current policy requirements in MySQL. ...
5 hours ago