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.
Posts
Recording: How To Run AI Agents Natively In Your Database
-
AI agents are only as powerful as their connection to data. In this
session, Oren Eini, CEO and Co-Founder of RavenDB, demonstrates why the
best place f...
1 week ago
No comments:
Post a Comment