Contents tagged with SQL
-
A harsh reminder that you can't forget what's below the abstraction
So you're a high-level programmer that much that you write software in Flash. Running in JavaScript. In a browser that runs on a virtual machine that runs on an actual OS that... Or simply you write a module that runs in a framework running on a framework running on a framework running on a framework (Orchard - ASP.NET MVC - ASP.NET - .NET) that uses an abstraction of database tables (records) aided by a layer that abstracts a layer that abstracts a data storage (Content Query - NHibernate - SQL) - that BTW itself abstracts a whole lot of things - to wrap it up quickly. And you thought you don't have to think about all that below! Got ya!
I've created a content part that had an innocent little property called Index (what, for the historical accuracy, was of type int), and below that there was a similarly named property in the part record. Guess what I got when I tried to use this?
-
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 :-).