Contents tagged with database
Modifying another Orchard module's DB schema with SchemaBuilder
The SchemaBuilder, the service you use in migrations to modify the database schema of your module is a convenient tool. However, you can't use it directly to modify the schema of tables defined by other modules (this is commonly the case when wanting to add indices to other modules' tables) because SchemaBuilder automatically appends you module's name to the manipulated table's name... But this is very simple to overcome!
SQL database scripting/diff tools that work
Recently I needed software for one very specific task: given two databases, calculate their (data and schema) differences and generate an appropriate change script. There are dozens of solution for this, but I tried many till I found two that satisfied the following criteria:
Backing up and restoring SQL Server databases on a remote server
So you want to use a decent SQL Server database for your ASP.NET application (e.g. an Orchard site :-)), both when testing locally and in the hosting environment. Now how to backup or restore these databases, so you'll more or less see the same in either environment? I'm glad you asked :-).